Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I need month wise max data, sample data is shared below
PLAYER | MONTH | RUN |
A | MONTH1 | 10 |
A | MONTH2 | 20 |
A | MONTH3 | 13 |
B | MONTH1 | 14 |
B | MONTH2 | 16 |
B | MONTH3 | 40 |
C | MONTH1 | 45 |
C | MONTH2 | 60 |
C | MONTH3 | 1 |
output:
Month | Player | Run |
MONTH1 | C | 45 |
MONTH2 | C | 60 |
MONTH3 | B | 40 |
trying with expression but is it now working : SUM(AGGR(MAX(SUM(RUN)),MONTH,PLAYER))
Straight table
Dim : Month
Exp 1 (Player) : FirstSortedValue( distinct Player, -Run)
Exp 2 (Run) : Max(Run)
Hi tresesco,
Wanted to know for this scenario if there are two dimensions Player and Month.
How can we write 1 expression in order to get the output.is it possible? Thanks
Thanks tresesco, Can we build expression using AGGR function?
You can. Is there any specific reason why you would like to use aggr() here? In general, thumb rule is - avoid using aggr() wherever you can.