Hello everyone,
I have a coloumn with a lot of numbers and as an example i have uploaded a screenshot of it.
I wanted to classify them into groups so i wrote a case when like this :
CASE
WHEN KPI("max_potential_saving") BETWEEN 7000 AND 70000 THEN 1
WHEN KPI("max_potential_saving") BETWEEN 1000 AND 7000 THEN 2
WHEN KPI("max_potential_saving") BETWEEN 800 AND 1000 THEN 3
WHEN KPI("max_potential_saving") BETWEEN 600 AND 800 THEN 4
WHEN KPI("max_potential_saving") BETWEEN 400 AND 600 THEN 5
WHEN KPI("max_potential_saving") BETWEEN 200 AND 400 THEN 6
WHEN KPI("max_potential_saving") BETWEEN 0 AND 200 THEN 7
ELSE 8
END
but when i sort it based on the classification it does not show the Max Potential Saving in order from highest to lowest. Does anyone have an idea ?
Thanks in advance !
