Below is my data for a sickness report. I am trying to do two things so that I can report on the sickness periods and duration.
The Row Number column should start from 1 again on date/row 1/9/2021
I have tried several Windows Functions but the data is not structured correctly
The Sickness Period column should be grouped and say 2 on date/row 1/9/2021
Any ideas what I could do to re-structure the data to work with Windows Functions and to group in Sickness Periods?