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