Splunk Search

Value to the right of the y-axis

epacke
Path Finder

Dear experts!
Happy new year to you all. 🙂

Got a strange thing when I am creating a timechart in Splunk in the panel of one of my dashboards. One of the values are shown to the left of the y-axis.

http://i.imgur.com/NLO10Jx.png

When I run the search manually I don't get the same visual result:

index="webfront" sourcetype="iis_w3c_min" host=BMA-WEB* (time_taken>16000 OR sc_status=500)  s_port=40*  (c_ip=1.1.1.1 OR c_ip=2.2.2.2) | timechart count by s_port

The panel is a default timechart panel:

<panel>
      <chart>
        <search>
          <query>index="webfront" sourcetype="iis_w3c_min" host=BMA-WEB* (time_taken>16000 OR sc_status=500) $siteiis$ (c_ip=1.1.1.1 OR c_ip=2.2.2.2) | timechart count by s_port</query>
          <earliest>$time_tok.earliest$</earliest>
          <latest>$time_tok.latest$</latest>
        </search>
      </chart>
    </panel>

Thankful for any help!

Tags (2)
0 Karma
1 Solution

acharlieh
Influencer

What I think is happening is Splunk is attempting to pick and display a label for the Y-Axis. You probably want to specify some options for customizing how the results are displayed (there are a lot of options available). For reference to the XML: http://docs.splunk.com/Documentation/Splunk/6.2.1/Viz/ChartConfigurationReference

In this particular case to hide the Y axis title:

<panel>
   <chart>
     <search>
       <query>index="webfront" sourcetype="iis_w3c_min" host=BMA-WEB* (time_taken>16000 OR sc_status=500) $siteiis$ (c_ip=1.1.1.1 OR c_ip=2.2.2.2) | timechart count by s_port</query>
       <earliest>$time_tok.earliest$</earliest>
       <latest>$time_tok.latest$</latest>
     </search>
    <option name="charting.axisTitleY.visibility">collapsed</option>
   </chart>
 </panel>

Or instead if you want a custom label you could set charting.axisTitleY.text to the text you want displayed.

Additionally if you're building this dashboard in SplunkWeb there are some UI based editors that can help you set many of the charting options: http://docs.splunk.com/Documentation/Splunk/6.2.1/Viz/Editdashboardpanelvisualizations

View solution in original post

0 Karma

acharlieh
Influencer

What I think is happening is Splunk is attempting to pick and display a label for the Y-Axis. You probably want to specify some options for customizing how the results are displayed (there are a lot of options available). For reference to the XML: http://docs.splunk.com/Documentation/Splunk/6.2.1/Viz/ChartConfigurationReference

In this particular case to hide the Y axis title:

<panel>
   <chart>
     <search>
       <query>index="webfront" sourcetype="iis_w3c_min" host=BMA-WEB* (time_taken>16000 OR sc_status=500) $siteiis$ (c_ip=1.1.1.1 OR c_ip=2.2.2.2) | timechart count by s_port</query>
       <earliest>$time_tok.earliest$</earliest>
       <latest>$time_tok.latest$</latest>
     </search>
    <option name="charting.axisTitleY.visibility">collapsed</option>
   </chart>
 </panel>

Or instead if you want a custom label you could set charting.axisTitleY.text to the text you want displayed.

Additionally if you're building this dashboard in SplunkWeb there are some UI based editors that can help you set many of the charting options: http://docs.splunk.com/Documentation/Splunk/6.2.1/Viz/Editdashboardpanelvisualizations

0 Karma

epacke
Path Finder

I solved it by moving the legend to the bottom. Needed to do that anyway to align the graphs.
Thanks for your help!

/Patrik

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...