I would like to see if something (ie, number of transactions/hour) is within an expected range. I have a search that returns a single row with the fields Recent, High, Low.
I am trying to visualize this with a Radial Gauge, but am having trouble getting the range values set correctly.
<chart>
<search>
<query>... | fields Recent, High, Low</query>
<done>
<set token="lowThreshold">$result.Low$</set>
<set token="highThreshold">($result.High$</set>
<set token="max">eval(round(result.High$ * 1.2), 0)</set>
</done>
</search>
<option name="charting.chart">radialGauge</option>
<option name="charting.chart.style">minimal</option>
<option name="charting.chart.rangeValues">[0,$lowThreshold$,$highThreshold$,$max$]</option>
<option name="charting.gaugeColors">["0xBF3030","0x7e9f44","0xBF3030"]</option>
</chart>
This keeps ignoring the token settings and using the defaults of 0, 30, 70, 100. What do I need to change to use my ranges instead of the default ones?
Thank you!
Try this in your query...
<query>... | gauge Recent, Low, High</query>
Hi,
just a short note here:
did you recognize the extra "(" in ($result.High$ in line 6?
Try this in your query...
<query>... | gauge Recent, Low, High</query>
That changed my result from Recent, High, Low to x, y1, y2 but the gauge looks the same.
Interestingly, the gauge first displayed it looked (almost) right...for a second. And then flashed back to the defaults.
If you're setting the gauge in the search itself, get rid of charting.chart.rangeValues
.
Huzzah! That works! Thank you!
I see the doc for it now. https://docs.splunk.com/Documentation/Splunk/6.5.0/SearchReference/Gauge