How to calculate number of continuous weeks of Submitted Timecards
For Casual workers who submit weekly timecards, I need to identify those that have worked 12 continuous weeks.
Content (please ensure you mask any confidential information):
I'm trying to create an OTBI report to identify Casual workers that have worked continuously for 12 or more weeks. Casuals submit weekly timecards via OTL, so I could distinct count the number of timecards per assignment over the last 12 weeks from Current Date, using a TIMESTAMPADD formula to set the date range. I could also repeat this to identify Casual Workers approaching 12 week's continuous service so I can alert managers. Heat Matrix also allows a visual representation at an assignment level.