Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need some help with an expression.
The following works fine and gives me the day(my_date) when the number of people(id:s) are the most.
concat(aggr(if(rank(Count(DISTINCT ID),1,1)=1, MY_DATE), MY_DATE),',')
What I am looking to do is to pick the day(my_date) when the number of people(id:s) are the least.
Anybody know how to do it? I figure I can do it with rank but have been unsuccessful so far.
Thanks,
Johan
try a negative expression in your rank function:
rank( -count(Distinct ID),1,1)
Hope this helps,
Stefan
try a negative expression in your rank function:
rank( -count(Distinct ID),1,1)
Hope this helps,
Stefan
Thanks for your quick reply.
I had no idea I could do a negative expression inside the rank function.