Thank you a lot to both of you @dadoonet and @Marco_Liberati. Has been a pleasure! I will try this and hopes it work. I will leave the post and solved.
Best of luck!!
Sorry to bother again. As I have to define 5 colours. Is it possible to use something similar to and/&& in formulas?
I have used some math tricks to make it possible to assign 3 different colors to a range, so it looks like:
ifelse(ifelse(average(KPI) >= 0.3, 1, 0) * ifelse(average(KPI) < 0.5, 1, 0) > 0, average(KPI), 0)
But I am stuck with hiding non-values on chart hints. See the attached picture.
@Marco_Liberati Could you provide any suggestions?
1 Like
I see. I think that's for now the only available solution with Lens formula.
1 Like
Thanks @Marco_Liberati and @msavitski for your answers. Should be enough for now
Nice to have such a good community
1 Like