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!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...