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!

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...

Announcing the Migration of the Splunk Add-on for Microsoft Azure Inputs to ...

Announcing the Migration of the Splunk Add-on for Microsoft Azure Inputs to Officially Supported Splunk ...