Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))
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
You can sort using this may be
Match(Only({1} [I feel I can trust my manager.]),'Strongly Agree','Agree','Neutral','Disagree','Strongly Disagree')
Try Using Num([I feel I can trust my manager.])