18 Replies Latest reply: Aug 20, 2015 8:30 AM by Sunny Talwar RSS

    max() function for charts

    xavier hemelaar

      Dear Community,

       

      I'm tring to use the max() function combinated with count().

       

      max([date import]) : gives me the date

      Count(ID): gives me the number of ID

       

      And what I want is to count only the ID when [date import] is max. So I tried different things:

       

      Count(if( [date import]= max([date import]), ID))

      Count({<max([date import])>} ID)

      ... It didn't work...

       

      I'm sure it's possible ! thanks for your help

       

      Best regards