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

[justcotto]

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%

[stevejoyce]

Your 2 tables can have Status as dimension...

Count({<Compliance={'Compliant'}>} ID)

Count({<Compliance={'Compliant'}>} ID) / Count(total ID)

2nd table would have Compliance={'Non-Compliant'}

[justcotto]

Thank you but hat only gives me the percentage of the total compliant. I already went that route.

[stevejoyce]

I don't follow your issue.  Can you post the output and what you are looking for?

[justcotto]

I want the percentage of the total count of compliant and non compliant

[justcotto]

that would give me 50% for each status totaling 200%

[stevejoyce]

so you want 50% and not 25%?

like this...

Count({<Compliance={'Compliant'}>} ID) / Count(total <Compliance> {<Compliance={'Compliant'}>} ID)

[justcotto]

I want 25%

[stevejoyce]

can you screenshot what you are trying to do.  see attached, results are 25%.  first calculations i sent.

[justcotto]

I could be that I am using Distinct. I created the same inline tale and it works as we are describing