1 Reply Latest reply on Jul 5, 2017 6:55 AM by Rafi Zelikowsky

    Stack Bar Chart Sorting - Descending order

    Muhammad Adeel Ahmed
    Muhammad Adeel Ahmed Jul 5, 2017 6:49 AM

      Hi Gurus,

       

      Can you please help me to sort the Stacked bar chart as per % values of dimension.

       

      I have 5 Bands and I want the bars to sort in such a manner that Band 5 is 1st priority, then Band 4 is 2nd priority, then band 3 and so on.

       

      Unfortunately I can't share the table due to confidential reasons but I have attached the snapshot showing what ouput i have.

       

       

       

      I want the chart to look like below chart (someone in this forum has shared this example but unfortunately i couldn't implement it in my table.).

       

      BR

      • 188 Views
      • Tags:
        • 1. Re: Stack Bar Chart Sorting - Descending order
          Rafi Zelikowsky
          Rafi Zelikowsky Employee Jul 5, 2017 6:55 AM (in response to Muhammad Adeel Ahmed)

          Hi there,

           

          Unfortunately you cannot apply a percent of total function on 'measure values' as it is a bucket for multiple fields.

           

          To achieve the chart that you're looking for, it would be best to pivot your data so that you have one column for the value and another column for the band type.

           

          Once you've done that, you can add a quick table calc on the 'Value' measure for percent of total, and compute that by band type.

           

          Hope that helps!

           

          Rafi