0 Replies Latest reply: Apr 9, 2013 5:36 AM by Annabelle Weixler RSS

    Table Problem - Aggr, Timestamp and Sum

      Hi,

       

      i have some problems with a table. I made a picture to realise what i want.

       

      a.) is there a better way to reduce "All Timestamps" to Max? and delete the null-values( with Distinct in the script or smth else...(yes I have checked "hide null values"))

      b.) afterwards I want to caloculate the time  interval between the 1st and 2nd (time 1), the 3rd and 4th (time 2) etc

           - watch out there are different status. i only want to build the differences within the same status. (see time 4)

       

      Thanks for help

       

      test.png