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