Can I create a custom hierarchy of measures
I saw this article, https://community.pyramidanalytics.com/moderate/t/h7h92p1/how-to-combine-values-from-different-measures-in-one-charts.
Is it possible to create a custom hierarchy of measures? in my example, I built 4 measures in Formulate using formulas. 3 of the measures add up to the 4th. Could i create a custom hierarchy with these 4 measures?
No, we do not support hierarchies in the Measures dimension.
You could try to create a dimension table (suppose it's called MeasuresTable), which will have 2 columns, like this:
Bottom Measure Top Measure
Measure A Measure Total
Measure B Measure Total
Measure C Measure Total
And set up a hierarchy called "MeasureHierarchy" with 2 levels, Top Measure and Bottome Measure.
Then create a formulate that basically says:
"Measure Total", ##formulate for the agg measure##,
"Measure A", ##Formulate for Measure A##,
"Measure B", ##Formulate for Measure B##,
"Measure C", ##Formulate for Measure C##,
I hope this works, also not sure if it will be very performant.
Another Approach is to use formatting to differentiate the total from the components. using a bold header, a background color etc.