13 Replies Latest reply: Dec 7, 2017 11:27 PM by neha shirsath RSS

    Sorting X Axis variable

    ra ta

      Hello, I need to sort the x axis on a chart where the variable takes one of these 5 values:

       

      Alpha, Beta, Gamma, Not Applicable, or None. And i tried the following in "Sorting by Expression" field:

       

      if(Variable='Alpha',1,if(Variable='Beta',2,if(Variable='Gamma',3,if(Variable='Not Applicable',4,5))))

       

      but this has not given me the expected result. Any suggestions how to fix this please.

       

      Thanks and regards,

      Ra