I'm not sure if the below is possible but thought I'd ask for some suggestions. I have a number of KPIs that are used across a number of different sites and all of which have their own targets, on which a RAG status is calculated. What I require is, that rather than the KPIs being displayed in a table format with their RAG colour beside them, all of the RAG statuses are consolidated into a Pie Chart with it simply showing the breakdown of the RAGs, e.g. 50% of the KPIs are green and this is shown with a pie chart being broken up to display half of it green.
The current chart has variables in it so that end users can select particularly weeks to see the spread across differents sites. We have 4 sites and I would want to see 4 different pie charts showing their respective RAG statuses.
Let me know if you require any further information.
For information, below you can see how I currently attach a RAG status against each KPI. I'm not sure this can be added as a second dimension as each KPI has a different method to calculate the RAG status