1 Reply Latest reply: Mar 30, 2016 11:14 AM by Gysbert Wassenaar RSS

    How to get the average of certain rows

      How can i calculate the average value of certain rows?
      as for example i want to calculate the average VALUE between start1 and end1 which is the average of (4, - , 5, 3, 4, 5) and the average value between start2 and end2 which is the average of (8, 8, 9, 7, 9, 8).

       

      eventValue
      start 1
      process4
      action
      reaction5
      end 1
      start 2
      process8
      action8
      reaction9
      end 2
      start 1
      process3
      action4
      reaction5
      end 1
      start 2
      process7
      action9
      reaction8
      end 2