Sort columns by sort in another column

[Woojtek_96]

Hi all,

I want to sort values in Dest, Food and Price in way how's Dep_date are presenting. Now for example I have:

2019-09-10, 2018-10-14, 2018-12-13 with Dest ACE FNC TFS but in a correct order it should be ACE TFS FNC, is possible to sort it that like it refers to Dates in Dep_date column? All values are made with concat function and i just need to replace strings to the correct order which will match with the dates.

Thanks for all help

[juliensaintmaxent3113]

Hello,

do you try to modify the sort in the parameters of the chart.

In the menu sort you can set the sort of each field with an expression.

Bye

[Ezir]

Hello,

I believe you need to sort the data before concatenation.

[Woojtek_96 · Accepted solution]

I made it by adding sort_weight to concat function. Thank you very much for guide