Hello everyone,
hope you're doing well !
I have a FLAG column (with value =ok), I would like to count the number of 'ok' from each date (present in the table) and until an endDate (which is the Date+10 days, which is not calculated yet)
I'll try to explain with the dataset below:
so I need to count the number of FLAG where FLAG equal 'ok' on date range (FabricationDate), starting from the date which is on the line itself until FabricationDate<=FabricationDate + 10 days.
What is need to get is described on the red column (final expression).
Hope it is clear.
Thank you for your time.
Youssef