Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table with linear gauges. I set up color segment by variable orderIDColor.
It shows light gray color by default, but when I select any value from orderIDColor or variable itself, it shows right color.
Where is my mistake?
Thanks,
Expression Tab
Gauge Setting
Segments Setup
Color
Define Calculated Color as
IF(GetSelectedCount(orderIDColor)=0,RGB(3,135,171),orderIDColor)
Hi Manish,
It doesn't work, it shows blue color for all of them, but if I select any tag, then it shows right color.
Thanks for helping me.
you can achieve this without having to go the gauge chart route as i am unable to change the background either. not sure why that would not work.
but check attachment...not clean in terms of making it but visually similar results.
Hi.
It's common problem. The expressions in gauge preferences is calculated once for the entire chart.
So that you can't set different min/max for segments refer to dimension values.
So other words my problem won't be resolved.
did you see my response above? there is a work around!
It works, but in my case. I need to switch between channel / campaign. It's difficult to match all rows and bars.
Some clients have more 50 campaigns and 10 channels. Web view has small difference in view.
Thanks for reply.
You can try to redesign it.
For example, you can use =orderIDColor as a background color for the gauge expression to colorize the cell background.
Then you can make the gauge segment transparent and keep the only needle without filling (toggle hide boundaries an outlines also).
It depends on the message you're trying to send.
Like this?
