4 Replies Latest reply on Mar 30, 2015 6:08 AM by Vladislav Grigorov

    aggregate timedifferences between timestamps of datarecords by type

    Marc-Andre Sabelmann

      Do you knoe a bestpractice way to aggregate the time difference between consecutive records?

      For instance I have a table for status. I have 5 Statustypes. Everytime the status changes, I have a new record on the table with the respectively time stamp a type of status. So I have thousands of such entries in my table.

      Now I want to determine how long was each status. That means, I have to determine the difference between the timestamps and aggregate them by status types. Any Ideas?