4 Replies Latest reply: Nov 14, 2012 6:13 AM by Ralph Graham RSS

    Consolidating data to new chart type

      Hello,

       

      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.

       

      Thanks,

       

      Ralph

       

       

      KPIDataRAG
      Sales30Red
      Profit35Green
      Attendance2Green
      CoS34

      Amber

      Accidents4Red
      Share32Green