10 Replies Latest reply on Nov 29, 2018 5:17 AM by Zhouyi Zhang

    Calculate Time difference based on condition

    Shruthi B S

      Hi All,


      I have use case in my current requirement where in i have to calculate the time difference between 2 actions. I have sample data below.



      I want to calculate time difference between action taken by "Team 3" from previous action for each Ticket Number. I do not want to use "Lookup" function here as i want to use aggregated measure in my view.

      For instance, Ticket Number =101 , Time difference shuld be (1/1/17 3:08PM  - 1/1/17 1:52PM = 4560 secs)