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