Forum Discussion

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
7 years ago
Solved

Sorting site names as per active order

Hi  i have few list of sitenames which i need to sort the order of the sites which is active.   List: Germany Norway Milan China Finland south africa Venezula     How to get the above or...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    7 years ago

    Hi

     

    I have resolved it.

     

    Created one new column and applied switch statement with 1,2,3,4,5,6.. and so on. and i have sort the column by sort by column mode. able to get the visual as per requirement.

     

    Thanks.

     

    Regards,

    Rajendra

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago

Not sure if this 'solution' is the solution that matches your problem...

But under the tab 'Modeling' you can find 'sort by column'. If you would use this, the alfabetical order will be overruled by the sort that you request from another column. 

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
7 years ago

Hi

 

I have resolved it.

 

Created one new column and applied switch statement with 1,2,3,4,5,6.. and so on. and i have sort the column by sort by column mode. able to get the visual as per requirement.

 

Thanks.

 

Regards,

Rajendra

  • DouweMeer's avatar
    DouweMeer
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    Cheers