4 Replies Latest reply on Mar 30, 2017 9:35 AM by Ben Newell

    How can I count the number of sequential identical values?

    Brian Armstrong

      I am having difficulty figuring out how to count the number of sequential identical values in a dataset. I would like a chart that increments by 1 every time [result] is FAIL/0 and return to 0 when [result] = PASS/1 occurs. The values PASS/FAIL and 0/1 are arbitrary - they are defined by a calculated field that determines the [result].

       

      For example, my x-axis is TIMESTAMP. As time progresses, I want the chart to rise each time a failure occurs and return to 0 with a pass.