Sorting Y axis by count


how to sort the Y axis by the count of completed with sort order descending?
Thank you!

Hi @ling
You can check the sort options. Here s sample.


BR

1 Like

hi ErikG,
I checked the sort options but it can only sort by the training status which including completed, in progress, and not started. I wanna to make it just sort by “completed”. Could you advise how to make it? Thanks!

image

screenshot for reference.

You would expect somthing like


right?

I think that is not possible (based on Training Status Count if you want to display “not started” too. Do you have a measure you could use instead?

Hi @ling
Did you found an solution?
BR

1 Like

Hi @ling you are on the right track with these custom sort options. You first need to make a calculated field that only has the Completed values in it, and then choose that new field in this sorting menu.

ifelse({Training Status}=''Completed", 1, 0)

Then in the sort, choose this field with SUM aggregation on it.

1 Like