3 Replies Latest reply on Aug 23, 2018 11:19 AM by Esther Aller

    Filtering data by seconds ran from last known valid result


      We're trying to create a calculated field (Is Valid?) to reproduce the logic below. It is a binary result that:

      - it is 1 if it is the first known value of an ID

      - it is 1 if it is 3 seconds or later than the previous "1" of that ID (note1: this is not the difference in seconds from the previous record)

      - It is 0 if it is less than 3 seconds than the previous "1" of that ID


      Note 2: there are many IDs in the data set

      Note 3: We want as a calculated field to filter the data in many existing reports, that's why a table calculation is not ideal.


      Attached a PoC of the data and the expected result.

      Any ideas?