Consecutive day counter in ES5
I am trying to write logic in ES5 (in BIRT) to assess if an employee has worked 10 days in a row. I have extracted the start dates but can’t seem to get the logic to work as intended. If an employee clocks in on the 14th, for example, and they clock in every day between that start date and the 24th, then that should be recorded in a column to signify that 10 consecutive clock ins have been found.