2 Replies Latest reply on Jun 14, 2016 5:42 AM by Gabriella Chandra

    Sum Times When Consecutive Statuses Match

    Gabriella Chandra

      Hello,

       

      I have a set of data that gives me the state of a light every minute. I would like to sum the amount of time the light was in a certain state and display in a graph as separate occurrences. Below is the graph I would ultimately like to get:

       

      I have attached the data set as well.

       

      Thanks!