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