Column formating Splunk studio

[Aresndiz]

Does anyone know if it is possible to create specific thresholds for each host in the dashboard studio table? I'm using a table where I focus on hard disk usage, previously I had no problems with the configuration since the threshold was 80% amber and 90% red. However, I was asked to adjust this threshold to 90 amber and 95 red only for a specific server. My question is, is it possible for the color format table to have different thresholds depending on the host?

[livehybrid · Accepted solution]

You can do this by overwriting some of the options within the table source:
Have a look at the following example:

 

You can see that the colour is specified using SPL instead of logic within the Dashboard editor. Using a field prefixed with underscore _ will stop it showing in the table.
Then update the options for the table and add/edit the columnFormat:

        "columnFormat": {
            "<YourHighlightedField>": {
                "rowBackgroundColors": "> table | seriesByName('_colour')"
            }
        }

I hope this helps!