Problem with column sorting

ozarkram
ozarkram Member
in Magic ETL

Hi All,

I am sorting a dataset in the visualizer...I am sorting by the dealer name and whether the item got shipped or not and then by the order date all in the ascending order...

The beast mode that I am using for the shipped or not beast mode is the following:

CASE WHEN TRIM(`order_status`) = 'order shipped' then '1' 

ELSE '2' END

The problem that I am facing is that if I remove the shipped or not from the columns (I am table chart) then the sorting get messed up meaning (dealer name ,shipped, not shipped,shipped appear as jumbled when the beast mode field is removed from the columns and just kept in the sorting in the left...

Do you have any suggestions..

Tagged:

Best Answer

  • RobSomers
    RobSomers Coach
    Answer ✓

    Not 100% sure on how to fix the sorting when you don't have the column, but if you just don't want the column to show on the card, you can just hide it using Hide Columns under General chart properties.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

Answers

  • RobSomers
    RobSomers Coach
    Answer ✓

    Not 100% sure on how to fix the sorting when you don't have the column, but if you just don't want the column to show on the card, you can just hide it using Hide Columns under General chart properties.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • ozarkram
    ozarkram Member

    Thank you so much @RobSomers !..Really appreciate your help!

Categories