How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?

Summary:

I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period.

I have managed to create a report that picks up more than 4 absences for a rolling 12 months but not sure how to calculate where each absence has been over 3 days.

Could anyone help with my query?

Thanks

Mark

Content (required):

Subject Area - Workforce Management - Absence Real Time.

For this employee I want to calculate total and produce a single line rather than 5.

No of Absences (in this case 5).

No of Absences where duration is more than 3 (in this case it would be 4).