Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Resolved!
Dimension: Applications
Expression: Avg(AppScore)
Sort Expression: =count({<Class = {Promoter}, company={1}>} Class)/ count({<Class = {'Detractor','Passive','Promoter'}, company={1}>} Class)
Resolved!
Dimension: Applications
Expression: Avg(AppScore)
Sort Expression: =count({<Class = {Promoter}, company={1}>} Class)/ count({<Class = {'Detractor','Passive','Promoter'}, company={1}>} Class)