topic Re: set y axis limit on bar chart in Splunk Search

set y axis limit on bar chart

chadman — Fri, 05 Jun 2015 13:05:57 GMT

I would like the max number of my Y axis to be 60. I so have some numbers that are higher than 60 in my data, but I don't want them to scale the chart. Instead I prefer the line just go off the chart. I tried to do

  <option name="charting.axisY2.maxiumNumber">60</option>

but this did not seem to work.

I have also tried
<option name="charting.axisY.scale">log</option>

This help with the scaling, but would prefer something like option 1.

Re: set y axis limit on bar chart

richgalloway — Fri, 05 Jun 2015 13:51:47 GMT

Perhaps you have a typo in your option 1. It should be

<option name="charting.axisY.maximumNumber">60</option>

Re: set y axis limit on bar chart

woodcock — Fri, 05 Jun 2015 14:09:16 GMT

This is what works on one of my charts:

<option name="charting.axisY.maximumNumber">60</option>

Re: set y axis limit on bar chart

chadman — Fri, 05 Jun 2015 14:56:51 GMT

I use this, but still see the y axis scale going to 750. Something I'm missing? I do have number higher than 60, but I want the top of the scale to still be 60.

Re: set y axis limit on bar chart

chadman — Fri, 05 Jun 2015 15:06:06 GMT

Here is what I have.

<chart>
  <searchTemplate>sourcetype="_sort" host=$desktop$ | timechart avg(idle) as "Idle Time"</searchTemplate>
  <title>Idle Time</title>
  <option name="charting.axisTitleX.text">Date</option>
  <option name="charting.axisTitleY.text">Idle Time</option>
  <option name="charting.axisY.maxiumNumber">60</option>
  <option name="charting.chart">line</option>
  <option name="charting.primaryAxisTitle.text"/>

  <option name="displayRowNumbers">true</option>
</chart>

When I do this the Y axis still goes up to 700+ depending on the data

Re: set y axis limit on bar chart

richgalloway — Fri, 05 Jun 2015 15:08:54 GMT

If you're using copy-and-paste to post your XML then you still have a typo. There should be 4 m's in maximumNumber.

<option name="charting.axisY.maximumNumber">60</option>

Re: set y axis limit on bar chart

woodcock — Fri, 05 Jun 2015 15:10:00 GMT

I assume that the problem is that the max is a "don't let it be smaller" rather than "don't let it be greater" limit (which is how I have always used it). I am not sure how to do what you need short of using the search language to round your top values to your limit in the search itself.

Re: set y axis limit on bar chart

chadman — Fri, 05 Jun 2015 19:10:16 GMT

haha, that was it. Look at the little things first. Working now!