1 Reply Latest reply: Feb 6, 2018 9:46 AM by Sunny Talwar RSS

    Stacked Bar Chart Set Analysis

    Eaphy Mao

      Hello community!

       

      I'm trying to build a stacked bar chart that shows the count of the ranking divided by the total count of rankings for a distinct time period. My data is similar to the below. I have a stacked bar chart with time and ranking as dimensions, but i'm struggling to get the measure right. Ideally I would have 3 bars totally to 100% each and the ABC's for each time bar would add up to the 100%.

       

        

      TimeRanking
      1A
      1A
      1B
      1C
      1C
      2A
      2B
      2B
      2B
      2C
      2C
      2A
      3A
      3A
      3A
      3A
      3B
      3A
      3A
      3C
      3B

       

      Any help would be greatly appreciated.