pdkswan

SQL table content Gauge color mapping

Discussion created by pdkswan on Apr 2, 2018
Latest reply on Apr 2, 2018 by Abel_Leyva

We are creating a dashboard in which we are using SQL table as a widget. which is showing result of SQL query as interface status running behind it as a data source like.

 

Status 

1

2

1

1

2

1

1

 

We are rendering this result in gauge , We want to change color of gauge based on 

 

If status =1 

then color = green 

else 

color = Red 

 

We have mapped color also according above mentioned but it's not working. Please suggest

 

 

 

 

 

 

 

 

 

Outcomes