sorting in a bar chart

[mario-sarkis]

Hey All,

if I want to sort a bar chart by name

EXample:

Domain :

x

y

b

a

Lets say I want to show the bar chart

sort it like this

y

b

x

a

(sort the text as I want)

Hope you can help

Thank you,

[niclaz79]

Hi Mario,

There are multiple ways you can do this, either by having the fields be a dual type, meaning you can assign them both a numeric and string based value.

Or you can add another column that would contain the sorting value, eg:

SortValue    Text

1,                    'y'

2,                    'b'

3,                    'x'

4,                    'a'

And then sort by Expression SortValue ascending.

[sunny_talwar]

May be like this

=Match(DimensionField, 'y', 'b', 'x', 'a')