0 Replies Latest reply: Apr 2, 2018 2:16 AM by Michael Anywar RSS

    Aggregated timestamp intervals

    Michael Anywar

      Hello, I need some help on getting  time intervals between activities and summing up the total time taken to accomplish all the activities.

       

      S I have table in the format below:

       

      UserNameActivityTimestampDuration( Either Hours or Minutes)
      AActivity1T1
      BActivity2T2
      DActivity1T3
      AActvity3T4T4-T1
      BActivity3T5
      AActivity4T6T6-T4

       

       

      I would like to get the time interval between activities per user, which can be plotted on graph, and then also get the sum of the total time taken for all the activities.

      There is only start time. So the start of an activity marks end of the previous. execpt the first activity that has no predecessor. The start of the first activity marks the start of it all. T1->T4->T6

       

      Thank you.