Custom sort orders?

wjkelly
Level 3
Custom sort orders?

I have a calculated column called brand_status that calculates a store's engagement with a brand based on recent order behavior.

The statuses are "Activated" "In Activation" "Needs Reactivation" "Sampled"

Is there a way to define the sort order for these items so that I could sort the records based on something other than alpha or numeric?


Operating system used: MacOS Monterey v12.4

0 Kudos
1 Reply
anino
Dataiker

Hi,

I don't think there's a direct way to do that, however, you can use Switch case processor to set a numeric value in a new column for any possible value ("Activated" "In Activation" "Needs Reactivation" "Sampled").

Switch_case.png

Once you have all possible values configured, you can use this new column as sort column.

BR,

รlvaro

 

Technical Support Engineer