How to calculate number of continuous weeks of Submitted Timecards

Summary:

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):

Hi,

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.