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.
This is what works on one of my charts:
<option name="charting.axisY.maximumNumber">60</option>
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.
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
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.
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>
haha, that was it. Look at the little things first. Working now!
Perhaps you have a typo in your option 1. It should be
<option name="charting.axisY.maximumNumber">60</option>