7 Replies Latest reply: Nov 28, 2016 8:27 AM by Piotr Lipski RSS

    Combo Chart - Swap expressions and dimensions

    Piotr Lipski

      Hello,

       

      I have simple database with audits results:

           

      CountryGrouprestKPI1 KPI2
      Country1Group 1store112
      Country1Group 2store221
      Country1Group 1store333
      Country2Group 4store422

       

      I'm trying to do Combo Chart with few information:

      • Bars - Score per each store
      • Line - Trend for group
      • Line - Trend for country

       

      We should be able to analyze only 1 country and 1 group at the same moment.

       

      My problem is that I always have chart like below, so each restaurant and score.

      Bez tytułu.png

       

      I would like to get KPI category and each restaurant

      Bez tytułu2.png

       

      Next problem could be trend for Group and Country but as I think TOTAL will help me.

       

      Do you have any ideas ?

       

      Thanks,

      Piotr