topic Re: How can I control a Radial Guage's range values with result values? in Dashboards & Visualizations

How can I control a Radial Guage's range values with result values?

ScottSusman — Mon, 10 Oct 2016 15:42:13 GMT

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!

Re: How can I control a Radial Guage's range values with result values?

sundareshr — Mon, 10 Oct 2016 16:44:12 GMT

Try this in your query...

<query>... | gauge Recent, Low, High</query>

Re: How can I control a Radial Guage's range values with result values?

ScottSusman — Mon, 10 Oct 2016 17:27:22 GMT

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.

Re: How can I control a Radial Guage's range values with result values?

somesoni2 — Mon, 10 Oct 2016 18:00:57 GMT

If you're setting the gauge in the search itself, get rid of charting.chart.rangeValues.

Re: How can I control a Radial Guage's range values with result values?

ScottSusman — Mon, 10 Oct 2016 18:38:23 GMT

Huzzah! That works! Thank you!

Re: How can I control a Radial Guage's range values with result values?

ScottSusman — Mon, 10 Oct 2016 18:40:20 GMT

I see the doc for it now. https://docs.splunk.com/Documentation/Splunk/6.5.0/SearchReference/Gauge

Re: How can I control a Radial Guage's range values with result values?

casties — Mon, 11 Nov 2019 03:48:22 GMT

Hi,

just a short note here:

did you recognize the extra "(" in ($result.High$ in line 6?