1 Reply Latest reply: Oct 4, 2018 7:13 AM by Sunny Talwar RSS

    How to use Max Timestamp for measure expression

    Shikha Kumari

      HI,

       

      I am trying to use Max function along with timestamp function for calculation of measures, but getting an error in expression.

       

      My expression is:-

       

       

      Interval(

      sum({<[reto]={'Correctly created'}>}


      Timestamp(Timestamp#([edited date time],'YYYYMMDD hh:mm:ss'),'YYYYMMDD hh:mm:ss')

      -

      Timestamp(Timestamp#([detail end date time],'YYYYMMDD hh:mm:ss'),'YYYYMMDD hh:mm:ss')

      )

      ,'hh')*24



      Please suggest.