Hi
Im a report, I am doing a basic count on a field
| stats values(CycleCount00) as "Cycle count" by host
when "Cycle count" result is > 300, I need to color the field in red
when "Cycle count" result is between 200 and 300, I need to color the field in orange
when "Cycle count" result is < 200, I need to color the field in green
what is the better way to do this?
I have also tried this it doesnt let me to user greater or lower than...
<format type="color" field="Cycle count">
<colorPalette type="minMidMax" maxColor="#31A35F" minColor="#FFFFFF"></colorPalette>
<scale type="minMidMax"></scale>
</format>
Ithought about the rangemap command but I dont succeed to use it
is anybody cant help me please?
<dashboard>
<label>table sample</label>
<row>
<panel>
<table>
<search>
<query>| makeresults count=3
| streamstats count
| eval "Cycle count" = random() % 300 ,host="host_".count
| table host "Cycle count"</query>
<earliest>0</earliest>
<latest></latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="count">20</option>
<format type="color" field="Cycle count">
<colorPalette type="list">[#53A051,#F1813F,#DC4E41]</colorPalette>
<scale type="threshold">200,300</scale>
</format>
</table>
</panel>
</row>
</dashboard>
rangemap
is not need.
<dashboard>
<label>table sample</label>
<row>
<panel>
<table>
<search>
<query>| makeresults count=3
| streamstats count
| eval "Cycle count" = random() % 300 ,host="host_".count
| table host "Cycle count"</query>
<earliest>0</earliest>
<latest></latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="count">20</option>
<format type="color" field="Cycle count">
<colorPalette type="list">[#53A051,#F1813F,#DC4E41]</colorPalette>
<scale type="threshold">200,300</scale>
</format>
</table>
</panel>
</row>
</dashboard>
rangemap
is not need.
perfect thanks
You should be able to use rangemap for this.
Try:
...| stats values(CycleCount00) as "Cycle count" by host|rangemap field="Cycle count" low=0-200 elevated=201-300 default=severe
In your table, add:
<option name="classField">range</option>
when I add the option name range I have a issue :
Unknown option name="classField" for node="table"