This content has been marked as final. Show 2 replies
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.