Sorting Key

[#1]

I want to change the order of my key by customizing it (i.e. Not ascending, descending by x or y value)

I have the following items in my one table ('Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful').  This is the order I would like them in. 

How would I write an expression to sort them in this way?

Thank you!

[sunny_talwar]

May be a sort expression like this

Match(FieldName, 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful')

[its_anandrjs]

Maybe another one

Only( Match(FieldName, 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful') )

Or

Only( {1} Match(FieldName, 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful') )

[MarcoWedel]

Hi,

another solution might be to preload this field e.g. using an inline load and check the "sort by ... load order" option in the sorting tab of your chart properties:

tabSortStatus:
LOAD * INLINE [
    Status
    Not Started
    In Progress
    In Review
    Done
    Onboarding Unsuccessful
];

table1:
LOAD RecNo() as ID,
     Pick(Ceil(Rand()*5), 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful') as Status
AutoGenerate 100;

hope this helps

regards

Marco