Hi - I’m back!
I’m stuck on this new thing.
I have a measure - average (score) - this is an average of a batch of indicators for a given city.
The cities are in categories - say A and B.
I have a bar chart for each category of cities, showing their average score. All is fine.
Now I want to dynamically calculate the GAP between the highest and lowest in each of the cities in my chart (Category A and Category B).
I can’t create a min and max of a measure. That much I know (but not much else).
So how can I get the gap say between 55% and 23% for one category and 66% and 34% for the other category. Dynamically of course!
All help would be much appreciated.
I haven’t included a dataset… not sure it’s needed… but I will anonymize data if I need to!!
Mega thanks Erica