i am a bit confused while creating a webi report and would appreaciate your help.
My colums are date (from datebase) and measure (calculated for each date in report) and i need to check the lowest value of the measure for the upcoming 5 days from the perspective of each day in the first column line. e.g.
column 1: date between 30.11.2020 and 17.12.2020
column 2: measure) for dates from 30.11.2020 to 17.12.2020
column 3: my expected results für next 5 days starting from each day in column 1. In
Any idea how to archieve this in Webi? So far i didn´t get it done in Webi like using relativedate(), min(), ForEach, IN …
Thanks and appreciated a lot