Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help, please?
I have some fields
field1
field2
field3
field4
field5
....
I need field5 for max(field4) group by field1, field2, filed3 in a chart.
Thanks!
Hi,
Try like (As dimnsion):
aggr(if(field4= max(field4), field5),field1,field2,field3)
Regards
Rahul Lakhina