Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasdavis500
Creator III
Creator III

Returning Dimension Value that AGGR() Aggregated over

I'm trying to return the dimension value that AGGR() has created and aggregated over. I've used the following formula in an expression, with Month as my dimension in my chart, to find the max values every month:

=MAX(AGGR(SUM({<[Not_My_Dummy] = {'0'} , My_dummy = {'1'}, ResolutionDate -= {'Null'}>} ABC_Resolved_Dummy), ResolvedBy, Month))

aggr.png

However, I would like to return the Dimension Values that correspond to these numbers, is this possible? For example, in August, the Max count is 232, corresponding to John Doe. I wish to represent John Doe on this chart for August so it's easy to I.D. who is performing well...

0 Replies