I'm trying to pull the max value from a list of and display this across a chart....
I have created a dummy variable, as well as have a dimension to calculate across.
here's the formula I'm using:
=MAX(AGGR(SUM({<[Some_Var1] = {'0'} , Some_Var2= {'1'}>} My_Dummy), ResolvedBy))
I also use a Month dimension in the chart that this expression lies, because I want the max value by month...
Here's sample data:
Month ResolvedBy My_Dummy
Jan Luke 1
Jan Luke 1
Jan Jeff 0
Jan Chris 1
Feb Jeff 1
Feb Jeff 1
Feb Chris 1
So, my chart would have Jan below my bar, the value of the bar would be TWO (2), and the person with the highest SUM would be Luke. For Feb it would be Jeff, again with TWO (2).
The formula above doesn't return the appropriate values, and I'm not sure how to return an appropriate Dimension Value that is acquired using the AGGR() function.