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 Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...