8 Replies Latest reply: Feb 25, 2017 4:22 AM by Shivkumar Maurya RSS

    How do you sort names within a field into order for a chart?

    Ricky Scheiber

      I have 13,000 items that belong to one of the following age bands. I want them to appear in a bar chart (measuring some other value) but in the following order:

       

      Age Band

      Past due > 360 days
      Past due 181 - 360 days
      Past due 91 - 180 days
      Past due 61 - 90 days
      Past due 31 - 60 days
      Past due 1 - 30 days
      Due 0 - 30 days
      Due 31 - 60 days
      Due 61 - 90 days
      Due > 90 days

       

      When I tried:

       

      match([Age Band]),'Past due>360 days','Past due - 360 days','Past due 91 -180 days','Past due 61 -90 days','Past due 31 - 60 days','Past due 1 - 30 days','Due 0 - 30 days','Due 31 - 60 days','Due 61 -90 days','Due>90 days')

       

      It didn't work. Thanks for your help in advance.