2 Replies Latest reply: Dec 10, 2011 3:19 PM by Johan Adolfsson RSS

    Help with expression

    Johan Adolfsson

      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