Sorting Y axis by count

Question & Answer
,
1

image
image798Ă—478 24 KB

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

2

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

image
image692Ă—312 21.8 KB

BR

1 Like
3

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

4

screenshot for reference.

image
image822Ă—480 22.2 KB

5

You would expect somthing like

grafik
grafik874Ă—198 2.98 KB

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?

6

Hi @ling
Did you found an solution?
BR

1 Like
7

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