Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart which plots the top ranking Customer over 2 days by hour.
The Expression used is: Sum({1<customer= {"=aggr(rank(sum(sales)), customer) = 1"}> } sales)
I'd like the Expression Label to be the customer with rank=1. I've tried this if(rank(sum(sales))=1,customer) but it's returning nulls.
Appreciate any help!
Try =only({1<customer={"=rank(sum(sales))=1"}>} customer)
Try =only({1<customer={"=rank(sum(sales))=1"}>} customer)
try below:
Sum({1<customer= {"$(=aggr(rank(sum(sales)), customer) = 1)"}> } sales)
Did you try using firstsorted value function and aggr that and to display
it in descending order use - sign
Awesome, thank you!!