I have bee trying to assign dynamic Gauge Segments in a Table expression. I got a few Indicators and unfortunately they have different RAG rating points.
For Example KPI - 1 RAG rating points are 0%-79%=RED, 80%-89%=AMBER, 90%-100%=GREEN
KPI - 1 RAG rating points are 0%-96%=RED, 97%-99%=AMBER, 100%=GREEN
It has trhe following table structure. Target table has all the necessary RAG point data for each Indicator (KPI)
Oroginally I though just assigning the [Amber Targ] and the [Green Targ] to each segment in the Gauge will atomatically get the relevent numbers based on each indicator and the Indicator number and the Indicator Description are the dimentions in the table. BUt I was getting all green Gauge without any segments.
Then see what they evaluate to, the result will get displayed on the button. Also if you hardcode the values for segments, it must show you what you are expecting. So you can test both ways and see whats failing.
Unfortunately Aleksandr seems to be correct, coloring the traffic light works when the boundaries are set manually (using a fixed value), but calculating them for each line of the table doesn't do the trick.