7 Replies Latest reply on Jun 19, 2018 2:02 PM by Rajkumar George

    Need assistance with "Time since last event" in Days, HH, Min and Sec format

    Rajkumar George

      Hello I am looking at designing a dashboard like the one below which will calculate the time since last specific event.

       

      I am using the below calculated fields to get the results of days and the last date of occurrence.

       

      for Days : MIN(DATEDIFF('day',[Reported Date],NOW()))

      For date : MAX([Reported Date])

       

      However, I could not think of ideas to include the hours, minutes and seconds left for the current day. Also I do not know on how to concatenate text like adding a super fix text "Days" "hours""Mins" etc., along with the values

       

       

       

      Appreciate any specific advice to achieve this.