I was looking for it to be done in a trend though dashboard actions. That way they can see how the percents are changing over time through whatever detail they want. This would allow them to identify spikes. Hierarchy would go -> Count > Type > Class > Code. Numerator would be the dashboard action and denominator would be 1 level up.
ex: Code selected count (numerator) / that code's class count (denominator).
ex2: Class selected count (numerator) / that class's type count (denominator)
Type, Class, and Code would be selected through my charts, so there will always be one level above it.
I slightly adjusted the calculation. Find the attached.
If I'm understanding it correctly, If I select 'Informational' from Chart 1, the two charts get filtered for that and Denominator of the second chart would be 341 as it it is the total of 'Informational' Type. Similarly, If 'Pending' is selected from Class, Chart 3 gets filtered and denominator is chart 3 would be 72.
Having said that, looks like there is a 1-to-1 relationship b/w code and class, so percentage would always be 100%. I'm not sure if the relationship is same in your original data source.
Book3.twbx 53.4 KB