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!

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...

New! Splunk Observability Search Enhancements for Splunk APM Services/Traces and ...

Regardless of where you are in Splunk Observability, you can search for relevant APM targets including service ...

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...