we have a speedometer graphic with the 3 classic segments (red, yellow, green).
We set the boundaries in this way:
- red (current result is worse than previous year)
- yellow (better than previous year)
- green (over target)
Values of segments are fixed as simple numbers.
But if we select some months or quarters or other products filters, of course the needle moves but boundaries are not referred to that month or that product. They obviously remain set for whole year result.
How can we set dynamic segment colors? Is it possible with some expressions?