Can measures and calculations be show under a grouping like dimension group? Lots of calculations and measures become overwhelming without some sort of organization
Thank you for writing to us.
Yes, measures and calculations can be grouped by specifying the
Here are two ways how grouping can be achieved:
folderproperty in the
/fieldsresponse (for custom data source API).
folderproperty in the calculation’s definition.
Please let us know if this helps.
Thanks for the response. What about grouping measures that are not calculations? They are used with standard sum for example. Also along the same lines can non calculated measures be shown together with calculations under the same group?
Thank you for your reply.
In case the custom data source API is used, our team recommends specifying the
folder property in the
/fields response to group non-calculated fields in folders (please see the following guide for more details).
Regarding showing non-calculated measures together with calculations under the same group:
We would like to kindly explain that at the moment, calculations are placed in a separate folder by design.
For adding functionality to your Field List the Flexmonster API calls can be used.
The general idea of how a custom Field List can be created is provided in the following thread: https://www.flexmonster.com/question/prevent-to-modify-fields-options/#answer-20339.
/fields response you can specify the folder in which the field should be shown.
If the folder name is specified the same as the folder name where Flexmonster places calculations, the corresponding field will be shown together with calculations under the same folder.
By default, Flexmonster shows calculations under the
"Calculated Values" folder. If desired, the folder name could be changed via
localization (please see our localization guide for more details).
For example, with the configuration in the code snippet below, the folder name for calculations is changed to
formulasGroupName: "All Values"
We have prepared a simple JSFiddle for illustration purposes: https://jsfiddle.net/flexmonster/pq64hsw8/.
In the example, all measures are placed in the same folder as calculations in the Field List.
The folder name for calculations is changed to
"All Values" via
"Price" measure and the
"Price Average" calculation are shown under the
"All Values/Price" subfolder.
Please let us know if this helps. If any questions remain, please feel free to reach out.
Looking forward to your reply.