Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort in Expression

I have used this expression before to sort the display order on a graph before.

Why does it not sort in the order?

This is in the Expression 

=Dual([I feel I can trust my manager.],match([I feel I can trust my manager.],'Strongly Agree','Agree','Neutral','Disagree','Strongly Disagree'))

 

3 Replies
arockiyaselvana
Partner - Creator
Partner - Creator

Hi Robert,

Its not matching maybe  because of some spelling mismatches between the field and match function values.

Can u pls share some sample data here.

In the mean time, you can try the below expression, if your dimension of the chart is [I feel I can trust my manager.],

Pick(match([I feel I can trust my manager.],'Strongly agree','Agree','Neutral','Disagree','Strongly Disagree'),1,2,3,4,5)

in Sort by Expression

sunny_talwar

You can sort using this may be

Match(Only({1} [I feel I can trust my manager.]),'Strongly Agree','Agree','Neutral','Disagree','Strongly Disagree')

sasiparupudi1
Master III
Master III

Try Using Num([I feel I can trust my manager.])