Sort by measure in columns plot doesn't work properly

[nickeichmann]

Describe the bug
I want to visualize this cube as a sorted column (according to the measure of the latest year) chart with grouped columns. When I choose the respective settings the plot sorts the columens neither the measures of 2020, neither the measures of 2022.

To Reproduce
Steps to reproduce the behavior:

1. Go to this visualization
2. Press at the bottom at "Copy and edit this visualization"
3. Edit the "Horizontal Axis: Programme"
4. See that "Sort by: Measure" is selected, but neither the blue, neither the orange bars are sorted. I aussume it is sorted by the average value or something like that?

Expected behavior
I would expect, that the bars are sorted by the values of the latest year.

Screenshots or video

Environment (please complete the following information):

• Visualize environment and version: 4.3.0

[bprusinowski]

Hi @nickeichmann, thanks for reporting the issue! Just a short answer to your question: currently we are sorting by sums per given X variable value (so summing up every bar in a given group).