I have a method of mapping numbers to text:
-1 → "unknown"
0 → "very low"
1 → "low"
2 → "high"
3 → "very high"
I want to be able to create a graph (bar, or line, or etc) using these values, but I want the label for the number to show as the associated text. I tried using beast mode to convert the numbers to text, but then the graph uses the text value instead of the integer value. How can I retain the value of the number while using the text for the actual graph label. (i.e. the x or y axis would show the text not the number)
(CASE
WHEN risk_level = 0 THEN 'Very Low'
WHEN risk_level = 1 THEN 'Low'
WHEN risk_level = 2 THEN 'High'
WHEN risk_level = 3 THEN 'Very High'
WHEN risk_level = -1 THEN 'Unkown'
END)