Sort by expression

[Kirsten]

Hi,

I currently would like to sort by expression to create a custom order of my barchart. Currently it is sorting by number: Field Replacements, Diagnostics, DEFOA, Factory Defects. But the order should change to: Factory Defects, DEFOA, Field Replacements, Diagnostics. (See Image).  I did read on the forum that this can be done by sort by expression: Match([PPG], 'Factory Defects', 'DEFOA', 'Field Replacements' and 'Diagnostics') which I added to in the expression editor, and did select apply. However after adding this, there is no change in my graph. (See image to see how it is applied in sort). What do I miss?

[lironbaram]

hi 

you didn't add any images 

can you add them 

[Kirsten]

Sorry 🙂 Can you see it now?

[JordyWegman · Accepted solution]

Hi Kirsten,

Try this:

Match([PPG], Dual('Factory Defects',1), Dual('DEFOA',2), Dual('Field Replacements',3), Dual('Diagnostics',4))

These duals will give an value to the names.

Jordy

Climber

[Kirsten]

Hi Jordy,

Thanks for the message. I have added the new expression, but it still does not have an effect on my graph. When adding the expression I click fX under sorting/sort by expression, then add the expression and click Apply. Sort by Expression is selected, sort numerically and sort alphabetically is unselected 

Am I missing a step to activate the expression in the graph? See Image

Regards, Kirsten

[lorenzoconforti · Accepted solution]

In the sorting section of your chart object, move the PPG section on top

[Kirsten]

Now it works. Thanks 🙂

[jcampbell]

Thanks for this. Very helpful!