Hi @power12, at first, don't use the search command after the main search: your searches are slower! I'm not sure that's possible to setup the cell colour in dinamic mode, maybe someone else knows this solution, anyway it's surely possible in static mode. Is it acceptable for you to add a Status field (OK,NOK) and give the colour to it? if yes, you could use a search like this: index=abc host IN (*) NOT (host IN (No_exclusions))
| eval
lower=((ref*l)+ref),
upper=if(u="null","10000000",(ref+(ref*u)))
| stats
latest(perf_number) AS perf_number
values(lower) AS lower
values(upper) As upper
BY host Test
| eval Status=if(perf_number>lower AND perf_number<upper,"OK,"NOK")
| table host Test Status perf_number lower upper then you can setup the Status colour based on the value. Ciao. Giuseppe
... View more