1 Reply Latest reply: Aug 6, 2012 7:36 AM by Edward Davies RSS

    Sorting a bar chart with a new expression - any ideas?

      Hi, hope someone can help


      I am trying to create a bar chart with one dimension and one expression and a 2nd expression to sort the bar chat:



      =if(Company='1', Applications)





      I am trying to sort the results based on a 2nd expression using the sort by expression in the sort tab:


      =count({$<Class = {Promoter}>} Class)/count({$<Class = {'Detractor','Passive','Promoter'}>}Class)


      This works perfectly in a straight table using 2 normal expressions but when I try in a chart it just doesn't sort correctly.  Any ideas would be much appreciated.