0 Replies Latest reply on Jul 19, 2019 3:02 AM by Matt Stringham

    Aging bucket sort order for charts

    Matt Stringham
      Share This:

      I have successfully setup the aging bucket as shown here Calculate Ageing buckets in Remedy Smart Reporting 9.1
      Here is how I have it setup in my table:

      To sort by days open I had to create another calculated field "Sort Days" and hid it, I did it this way:

      I had to do this otherwise the order was not correct, 181+ days was in the 3rd column.

      However the issue I'm having is that when I create a chart the sort order is incorrect:

      Here is the chart type and columns used:

      The chart order is not correct, notice the 181+ days is not where it is in the table:

      I looked at "Axis" and selected Horizontal and changed the "Ordering" to Table but it still has not solved my issue.

       

      Is there a way to solve the sort order?  Will I have to create reference codes at the view level?  Any recommendations?