I need to find the min/max value of a variable for further calculation, this gives me odd results.
Lets say I want the max. within the last 7 days.
So I create a rolling window with “max”, “every 7 days”, starting from date ‘today - 7days’.
Instead of getting now the max values I get odd results, but the max.
I need this value somehow to make percentage calculations in a derived variable.
Is there any solution for this?