Sick Leave Duration greater than XX days over a rolling period
We are trying to report on employees who have recorded more than 40 days of sick leave in a rolling 365 day period.
We have used Leave Duration and with no filter on this shows correct results, but when we add a filter like 'greater than 40' to the Leave Duration field it restricts the results to instances where the duration per instance is 40 days rather than the complete total of absences. For example the top record here should actually show over 200 days
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):