I have a requirement wherein the color of guage has to be red if the respective value is less than Min_Target,yellow when respective value is between Min_Target and Target,green when respective value is greater than Target i have done the same but the issue is that when no selections are made the guage chart looks equal spaced on each color ireespective of what the Min_Target and Target is for the respective metric is and when the selection is made on the metric name only then the proper color coding is seen in the chart. But i would want to see the correct color coding in the chart even when the selections are not made on the metric name.
For example metric b has its value as 2000 and its Min_Target=2000,Target=5000
So ideally the needle must point to yellow but when metric b is not selected the needle points to red and when selected it points to yellow
So can anyone let me know how this could be resolved.I have attached the application sample
By using a different visualisation (background coloring of the table cells, led's, etc..) you can avoid using the gauges and still telling the same story. Take a look at the attached example. I've used LED images instead of the mini gauge.