2 Replies Latest reply on Sep 26, 2013 3:21 AM by dilveer.kaur

    How do you have a chart that uses averaged values when you apply a filter on your dashboard for two or more options?

    dilveer.kaur

      Hello everyone,

       

      I have a dashboard on which I have put a map with 150 PCTs highlighted to tell us different things on them. For each PCT I have a breakdown of information that is displayed in a bar chart on the right. I have a filter which I can apply to the dashboard so I can select one PCT or all the PCTs in a region. When I do this, is their anyway to average the values in the data for those PCTs to produce one bar chart which is representative of all the selected PCTs instead of having lots of bar charts side by side?

       

      Thanks for all the help!

       

      Nikki