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..