1 Reply Latest reply: Dec 24, 2014 9:21 AM by Koen Bal RSS

    How to sort the values of a categorical - ordinal dimension on the axe of a chart?

    Koen Bal

      Hello,

       

      I would like to sort the values of a categorical - ordinal dimension in a specific order on the axe of a chart.

      The values and the order are:

       

           Identify Opportunity    
           Qualification
           Quotation
           Decision
           Close

       

      When these values are plotted on the axe they are by default plotted in a alphabetical order.
      Close
      Decision
      Identify Opportunity
      Qualification
      Quotation

      Which is not the order I want. I can change the order in properties>sort > expression.
      But what expression should I use?

      Thx for your advice, Koen

       

       

       

      Message was edited by: Koen Bal