Custom Sort Order

[wonkymeister]

morning,

struggling to engage brain today

i need to create a custom sort order for a dimension of text values.

ie

Car

Bus

Plane

Boat

etc

etc

any ideas? can DUALbe used in this scenario?

cheers.

[anbu1984 · Accepted solution]

In expression of Sort tab, use below

Match(Dim,'Car','Bus','Plane','Boat')

[stigchel]

Good morning,

Yes it's monday 🙂  And yes you can use the dual function. In load script load a dual value of the dimension, I would first load a map of sort order values

TextSort:

mapping load * inline [Text,SortOrder

'Car',1

'Bus',2

];

And then load the Dimension as

Dual(YourDim,Applymap('TextSort',YourDim)

In the chart sort your dimension by numeric value.

Regards,

Piet Hein

[jpenuliar]

Hi WonkyMeister,

If you have a long list of items in your Dimension,

You can have a numeric Flag assigned to each unique item.

Applymap from a master list(excel,txt, or db table)

[wonkymeister]

many thanks - got Monday morning brain fog