6 Replies Latest reply: Apr 15, 2014 6:14 AM by James McGarry RSS

    How to keep custom sort order in bar chart when displaying all values?

    James McGarry

      I have a simple bar chart showing production by hour. As the shift starts at 6am I have added the following sort expression;

       

      "Match([Hour], '6', '7', '8','9', '10', '11', '12', '13', '14', '15', '16','17', '18', '19', '20', '21', '22','23', '0', '1', '2', '3', '4', '5'  )  "

       

      This works but I would like the bar chart to display hours where there is no production. I therefore click the 'show all values' button on the dimension tab. The result of this is to move all of the 0 value bars to the left of the chart as in the screen shot below.

       

      Bar chart by hour.png

      Does anyone know how it i possible to keep these 0 value bars in their sort order?