asked on March 11, 2025
I am reaching out regarding support for the following customizations we are looking to implement on the Flex Monster UI:
Sum Operation on Decimal Field:
We have a sub-field of type decimal and would like to perform a sum operation on this field. As per the documentation, it appears that sum operations are only supported for numeric or integer fields. Could you kindly advise on any available customization options that would enable us to perform sum operations on decimal values as well?
Customization of Tooltip Data on Hover:
We are looking to display additional data when hovering over fields (specifically parent categories). By default, the tooltip displays the field name. We would appreciate guidance on how to customize the data displayed in the tooltip for these fields.
Any assistance or insights you can provide in achieving these functionalities would be greatly appreciated.
Thank you in advance for your support. I look forward to your response.
⋅ March 13, 2025
Hello,
Thank you for contacting us.
Please provide us with more details about your use case:
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 15, 2025
Thank you for the response. PFB for the requested deatails.
1. Using SQL Server as a Data Source
We are connecting data to Flexmonster through API calls.
Example: An API is called, which returns the required data that is then assigned to Flexmonster properties.
We are generating a report to track the uptime of a list of systems. The data is based on the hours recorded for each system.
The values for the hours are provided in decimal format, such as 2.5, 3, 5.5, 6.7, 0.5 hours, etc. The goal of the report is to calculate the total sum of hours for all systems.
As such, we require an aggregation function to calculate the sum of the hours field (in decimal format).
2. In the field list, please refer the attached screenshot.
We would like to display a tooltip for the "Date" field, with the tooltip content being different from the field data itself. Specifically, we would like the tooltip to display "System Date" for the "Date" field.
⋅ March 19, 2025
Hello,
Thank you for the details.
Please find our answer below:
Sum Operation on Decimal Field
We recommend using the mapping object to set the type of the field to number. For example:
report: {
dataSource: {
// other properties
mapping: {
Time: {
type: "number",
},
},
},
// other properties
}
Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/tzehq96c/. More details can be found in our documentation: https://www.flexmonster.com/doc/mapping/
Customization of Tooltip Data on Hover
Flexmonster does not provide functionality to customize the tooltip in the Field List. Alternatively, you can change the caption of the field in the mapping object. Please check our documentation for more information: https://www.flexmonster.com/api/field-mapping-object/#caption
We hope that our response is helpful.
Kind regards,
Nadia
