Count Issue: Counting regardless of Dimension

[#1]

Please see the picture attached above.

My dimension is "Supervisor." And I listed the accidents, first aid, and incidnet types.

My concern is that I would like to find out the percentage of each expression.

For example of utility, supervisor B had 2 utility incidents out of 4, which means his untility % must equal to 50%.

I would like to place each percentages for each expression.

Could you please help me on this issue? I've attached the files.

Thank you.

[Anonymous · Accepted solution]

Hi,

Please see attached.

Change your expresion to

count({<[Incident type]={'Utility'}>}Case#)/count(TOTAL{<[Incident type]={'Utility'}>}Case#)

Regards,

Greeshma

[danieloberbilli]

Please find attached

[#4]

Thank you so much!

[#5]

Thank you so much Daniel.