2 Replies Latest reply on Jan 29, 2018 11:15 AM by gabriela..zorrilla

    Aggregate result in discrete dataset. Workbook attached. 10.5

    gabriela..zorrilla

      Hi there. I've got a record of alarms that go on and off at an instant (value = 1 or value = 0). Using table calculations i can calculate how much time the alarm went on, but this works only if all the rows are there. I just want to have the alarm and the total time in a single cell, as shown in the workbook.

       

      Any tips? Workbook attached!

       

      Thanks!