Perfect. Thank you so much sorted. This is how its looking - example - <dashboard script="table_row_highlighting.js" stylesheet="table_decorations.css"> <label>Table Row Color based on String Time Duration in HH:MM:SS</label> <row> <panel> <single id="success"> <title>Success</title> <search> <query>index=kafka kafka_topic="*events*filter*sink" message.source="*velocloud*" | eval LatestTime=strftime(_time,"%Y-%m-%d %H:%M:%S") | eval TimeDiff=round((now()-_time)/60) | eval msg = case(TimeDiff >=59, "Delayed", TimeDiff < 10, "Successful", 1=1, "Middling") | eval range= case(TimeDiff > 90, "severe", TimeDiff > 59, "high", TimeDiff > 30, "elevated", TimeDiff < 10, "guarded", 1==1, "low") | table LatestTime TimeDiff msg range</query> <earliest>-24h@h</earliest> <latest>now</latest> </search> <option name="colorBy">value</option> <option name="drilldown">none</option> <option name="rangeColors">["red", "orange", "yellow", "blue","green"]</option> <option name="refresh.display">progressbar</option> <option name="trellis.enabled">0</option> </single> </panel> </row> </dashboard>
... View more