Exception - More than three absences in 6 months

[Former Member]

In my query I have absence data. In the rows I have the employee and the start and finish dates of their and then in the key figures I have the actual number of days absent. I want the report to highlight if an employee has m3 or more absences in a rolling 6 month period. How do I go about doing that?

[Former Member · Accepted solution]

Hi Joel,

I would consider adding a couple more Calculated Key Figures to your columns.

1. Boolean operator on number of days absence, = 1 if greater than 0 days

2. Data Function to sum the result of the Boolean operator aggregated to employee number

Then create an exception on this last column if greater than or equal to 3.

Hope this helps,

Nick