Splunk Search

set y axis limit on bar chart

chadman
Path Finder

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.

Tags (3)
0 Karma

woodcock
Esteemed Legend

This is what works on one of my charts:

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

chadman
Path Finder

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.

0 Karma

chadman
Path Finder

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

0 Karma

woodcock
Esteemed Legend

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.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

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>
---
If this reply helps you, Karma would be appreciated.
0 Karma

chadman
Path Finder

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

0 Karma

richgalloway
SplunkTrust
SplunkTrust

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

<option name="charting.axisY.maximumNumber">60</option>
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...