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

[#1]

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.

[#2 · Accepted solution]

Resolved!

Dimension:  Applications

Expression:  Avg(AppScore)

Sort Expression: =count({<Class = {Promoter}, company={1}>} Class)/ count({<Class = {'Detractor','Passive','Promoter'}, company={1}>} Class)