1 Reply Latest reply on Sep 15, 2016 8:42 PM by siyang.teo

    Count number of aggregated time intervals based on presence of another column value

    siyang.teo

      Hi, I am trying to create a field calculation that counts the number of the aggregates of a column and dynamically changes based on the time interval parameter, and number of days.

       

      E.g., In 2 days, if the interval is one hour, and data only exists within 20 hours, than the count will be 20.

       

      Attached is a sample twbx.

      I'm trying to create one count field for both 'speed' and 'health status' columns.

       

      Thanks!