I am trying to create a simple dashboard to track active site using a query like the one below. The query works and returns values but my supervisor has asked me now to add background color to the values in the dashboard. The query below basically checks to see if a service is running on a set of servers. If the service is running on server A it returns Town Name 1, if it is running on server B it returns Town Name 2. If neither is found it returns "Down". I have tried using Single Value visualization and Status Indicator Visualization but both require a numeric value to use the OTB color formatting. How can i get the background color to change based off the text values Town1, Town2, and Down? index=windows source=service host=servername* Name=service_name* earliest=-5m State="Running" | eval Site=if(host="server1", "Town1", if(host="server2","Town2","Down")) | dedup Site | table Site ... View more