Sorting by X axis by manual added field

Question & Answer
1

Hi,

I need custom sort X axis on charts and as there is no options at QS I made up some filed called Ordering and ordered in Table chart by Ordering. Works superb and when I hide Ordering column no one knows that exist. (ifelse(prob = “<-20.0%”, “A”, others) and so on up to ‘I’

prob Ordering
<-20.0% A
-20.0% - -10.0% B
-10.0% - -5.0% C
-5.0% - -2.0% D
-2.0% - 2.0% E
2.0% - 5.0% F
5.0% - 10.0% G
10.0% - 20.0% H
>=20.0% I

Problem…
When I try to sort like this at Clustered Bar Combo chart or any other Bar chart all settings are legit just ordering DOESNT work as I meant it. Like that is ignored completly.
At X axis I have chosen PROB column and for sorting I manualy choose ORDERING and is just randomly sort values not from A-I

Am I missing something or is a BUG?

1 Like
2

When you do the custom sort is it looking at the count?

image
image524×793 17.9 KB

Instead of ordering from A, B, C, etc… can you make it 1,2,3, etc… and sort by the average?

1 Like
3

Tnx for answer, I changed to numbers and same result. When I choose “ordering” column at BAR chart just doesnt work. Average is not available as an options for me.

SCR-20230215-eg1
SCR-20230215-eg1890×875 52 KB

4

Hi @matjazz,

I took @Max’s suggestion and made sure the field used for the “sort by” on the bar chart is a measure, then you can average on those values. See my examples below
image

image
image839×116 5.65 KB

image
image880×524 28.9 KB

Let me know if that helps,
Andrew

5

Khmm… Can you help me with how to make ifelse and mark as INT? Looks like this is a problem as is set to measure and average is still not an option.

ifelse(prob = “<-20.0%”, ‘1’, “Others”)

6

OK I changed to INT and changed to AVERAGE and WORKS!

Thanks guys for help!!!

2 Likes