3 Replies Latest reply on Jan 25, 2018 5:21 AM by Zhouyi Zhang

    Sort stacked bar/pareto chart by total # of records?

    Eric Kurtz

      In this simple example, I would like to sort the bar chart by *total* number of records within each Classification.

       

      Usually, I would do this by creating an extra discrete SUM(#ofrecords) calc (2nd screen shot below), hiding the header, and sorting it that way. However, when the bar chart is stacked, this would break apart the red and gray segments into different rows. Does anyone know how to sort this correctly so that they remain stacked?

       

      Should be sorted Repair, MCTE, Modification, 5S...

       

      Incorrect sorting breaks out the stacked values into different rows: