Custom sort orders?

Options
wjkelly
wjkelly Registered Posts: 22 ✭✭✭✭

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

Tagged:

Answers

  • Álvaro Andrés
    Álvaro Andrés Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 6 Dataiker
    Options

    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

Setup Info
    Tags
      Help me…