Require help with a set analysis with pie chart. I have attached the raw data file and the ideal outcome I would want to achieve is a dynamic pie chart able to cascade from year -> Quarter -> Recurring cases in red/yellow/green.
Most important visualisation would be the classification of colours in red/green/yellow in a quarter. Troubled by the set analysis behind the measures.
I am able to show the Values in 4 quarters but not zoom in on the individual quarters.
I have attached the following raw data along with a pictorial of what I want to achieve. Do provide me with insights on how to solve this problem.
Please be sure to close out your thread if you have the answers you need, given you have not responded to the last post on the thread, I am assuming that may have gotten you what you needed, and if so, please be sure to close the thread by using the Accept as Solution button on the post(s) that helped you resolve things. If you still require further help, leave an update and if you did something different, you can post what you did use and then mark that after you make the post...
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.