13 Replies Latest reply: Dec 7, 2017 11:27 PM by Neha Deshmukh 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,