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
Get Updates on the Splunk Community!

What the End of Support for Splunk Add-on Builder Means for You

Hello Splunk Community! We want to share an important update regarding the future of the Splunk Add-on Builder ...

Solve, Learn, Repeat: New Puzzle Channel Now Live

Welcome to the Splunk Puzzle PlaygroundIf you are anything like me, you love to solve problems, and what ...

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...