Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
CB308
Contributor III
Contributor III

Count Total Months (Rolling 12 Months) where % of Compliance is greater than 95%

For a Rolling 12 Months period, looking for a calculation of the number of months where the field % Compliance is greater than 98%

Rolling 12 Months % Compliance
Month 1 95%
Month 2 93%
Month 3 98%
Month 4 96%
Month 5 98%
Month 6 99%
Month 7 100%
Month 8 98%
Month 9 96%
Month 10 95%
Month 11 98%
Month 12 100%
   
# Months Compliant 7
(greater than 98%)  

CB308_0-1646514062790.png

 

0 Replies