Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
justcotto
Contributor III
Contributor III

Calculate count and percentage of total for a specific value in a straight table

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%
13 Replies
justcotto
Contributor III
Contributor III
Author

distinct isnt the issue

justcotto
Contributor III
Contributor III
Author

its not the distinct... bottom table is what it should be and top is what I am getting

screen.PNG

justcotto
Contributor III
Contributor III
Author

Count({<Compliance={'Compliant'}>} DISTINCT Login)

Count({<Compliance={'Compliant'}>} DISTINCT Login)/Count(TOTAL DISTINCT [Login])

justcotto
Contributor III
Contributor III
Author

I'm not getting why its not giving the right percentage. Broke down the numerator and denominator and still wrong

ex.PNG