Hello everyone. Is there any way to add aliases to...
# gd-beginners
a
Hello everyone. Is there any way to add aliases to values in GD insights?
m
Hi Alexander, This should be possible by using CASE and Conditional Number Formatting. Do I understand correctly that you would like to rename certain value in your insight to something else, e.g., [>=50] GOOD, etc.?
a
Yes. How can I add it?
m
You could define your metric as follow:
Copy code
SELECT SUM (SELECT CASE WHEN condition1 THEN 1, WHEN condition2 THEN 2 ELSE 3 END)
And then use number formatting:
Copy code
[=1]GOOD;
[=2]BAD;
[=3]NEUTRAL;
🙌 1
More examples can be found in the documentation linked previously
🙏 1