Sorting does not work in stacked bar chart

[Qliker4]

Hi everyone

I tried to sort this stacked bar charts.

It shows average worksteps for individuals and it should sort by the total of worksteps.

However, this chart does not really seem to order by anything.

Can you help here?

[seanbruton]

Hi,

Please try this.

Under the bar chart properties section Sorting. Untick all options, then tick the first Sort by Expression. Make the sort Descending or Ascending. In the expression add the same expression used in your measure.

If this does not work please share the names of your dimensions and your measure used.

Regards

[Qliker4]

Hi Seanbruton

Thank you so much for your support.

I already tried your way but it didnt work.

I sort by the following statement:

Count(Accessionnumber_ID)/ Count(Distinct Floor (Date))

The goal is to take the average number of Cases the person worked on per day.

When i remove the Workstep dimension it works.

It only breaks as soon as i add "Workstep"

Categories: Employees

Measure: Count(Accessionnumber_ID)/ Count(Distinct Floor (Date))

Legend: Workstep

Thank you and regards