Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data set:
ID | Compliance | Status |
1 | Compliant | Complete |
2 | Non-Compliant | Incomplete |
3 | Compliant | Completed Elsewhere |
4 | Non-Compliant | Exemption Declined |
Trying to create two tables that show count and percentage of total by status based on compliance
Compliant:
Status | Count | % of Total |
Complete | 1 | 25% |
Completed Elsewhere | 1 | 25% |
Non-Compliant
Status | Count | % of Total |
Incomplete | 1 | 25% |
Exemption Declined | 1 | 25% |
distinct isnt the issue
its not the distinct... bottom table is what it should be and top is what I am getting
Count({<Compliance={'Compliant'}>} DISTINCT Login)
Count({<Compliance={'Compliant'}>} DISTINCT Login)/Count(TOTAL DISTINCT [Login])
I'm not getting why its not giving the right percentage. Broke down the numerator and denominator and still wrong