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

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

    Edward Davies

      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:

       

      Dimension:

      =if(Company='1', Applications)

       

      Expression:

      Avg(AppScore)

       

      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.