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

    problem with table - Aggr, Sum, Timestamp

      Hi... I need some help with a table.

       

      a.) first is there another way to reduce "All Timeszamps" to Max and delete the null-Values?

                (I already tried DISTINCT but it doesnt work and I already checked "hide null values")

      b.) afterwards i want to calculate the time intervals between the 1st and 2nd Max-value (see time 1), between the 3rd and 4th (see time 2), and so on ..

           -->watch out they have to build the intervall with the next MAX value within the same status (see time 4)

       

      Thank you for your advice

      test.png