I followed @niketn 's syntax to produce a panel of table cells. My syntax is as follow:
<dashboard>
<label>Test2</label>
<row>
<panel>
<html>
<style>
#highlight table tbody{
display:flex;
flex-wrap: wrap;
}
#highlight table tbody tr{
margin-right:10px;
margin-bottom:10px;
}
#highlight table tbody tr td{
width: 180px;
text-align: center;
}
</style>
<div>
<div>Clicked Value in Cell (click.value):$click.value$</div>
<div>Clicked Cell Values (click.value2):$click.value2$</div>
</div>
</html>
<table id="highlight">
<search>
<query>index="omap_heng"
| fields host reception Station
| sort 0 +host
| search reception = *
| streamstats count by reception,host reset_on_change=true
| eval new_counter=if(reception == 1,0, count)
| table host new_counter Station
| streamstats max(new_counter) as max_counter by host
| sort 0 +host, -max_counter
| streamstats first(max_counter) as max_counter by host
| where new_counter=max_counter
| table Station,max_counter
| eval "Max Counter Info"=Station."###".max_counter
| fields "Max Counter Info"
| makemv "Max Counter Info" delim="###"</query>
<earliest>0</earliest>
<latest></latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="count">20</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</option>
<option name="percentagesRow">false</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
<format type="color" field="Max Counter Info">
<colorPalette type="list">[#53A051,#006D9C,#F1813F,#DC4E41]</colorPalette>
<scale type="threshold">0,6,11</scale>
</format>
<format type="number" field="Max Counter Info">
<option name="precision">0</option>
</format>
<drilldown>
<set token="click.value">$click.value$</set>
<set token="click.value2">$click.value2$</set>
</drilldown>
</table>
</panel>
</row>
</dashboard>
I would like to highlight each cells, based on a range on max_counter value (the circled value in my image below). Hence, if my max_counter is between 0 and 6, then green, if between 7 and 11, then orange and if above 11, red.
My panel currently looks like this now:
Pls help! thanks!
