In my dashboard, a table panel which have the percentage of a metric for each month is displayed. Below is the query details:
| stats avg(metric_perc) as Metric over Period by Host
Below are the results of my search query:
Sl.No, Period, host1, host2, host3
1 Jan 36 52 64
2 Feb 43 69 66
12 Dec 26 45 58
I want to highlight only the maximum the values of each host for each period.
[Note: Here host1, host2 and host3 are not column names they are values of the column called Host. As I used the keyword over, I got the above table representation with the combination of 3 fields such as Metric, Period and Host]
Could someone help me in finding how can I highlight or color code only the maximum value of Metric for each host and period.