Re: Reported ill more than twice over last 12 months.
The way I did this was to have absences as SCD (Slowly Changing Dimension) type 2
(Google will explain it better than I can). The fact is a snap shot in time.
Here's an example of the absences dimension table, (simplified)
I used intervalmatch() to match start and end dates to a master calendar, allowing me to create the fact table.
You can then count users by their absences. So in your scenario create a chart with person as the dimension and an expression asIF(COUNT(DISTINCT %keyAbsence)>2,1)
he user can just select their own start date and end date..
Hope that is of some help if not It would be helpful if you could upload a photo of your data model or even upload the actual dashboard (but I'm guessing this is sensitive data, so probably not an option!)