Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In expression of Sort tab, use below
Match(Dim,'Car','Bus','Plane','Boat')
In expression of Sort tab, use below
Match(Dim,'Car','Bus','Plane','Boat')
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
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)
many thanks - got Monday morning brain fog