Splunk Search

Two Y-axis graph: same line showing twice

sowings
Splunk Employee
Splunk Employee

I'm building a dashboard using the techniques described here on Splunkbase, so that I have two Y axes. What I'm seeing, however, is that there are two lines drawn for one of the data series. The legend only shows three sources. The second copy of the line hugs the X-axis line (as though it had Y value of zero). Attached is a screenshot. I can provide a sample of the XML, as well.Ghost Line

                          <param name="charting.data1.table">@data</param>
                          <param name="charting.data2.table">@data</param>
                          <param name="charting.data1.columms">[0,1,2]</param>
                          <param name="charting.data2.columms">[0,3]</param>
                          <param name="charting.chart.data">@data1</param>
                          <param name="charting.chart2.data">@data2</param>
                          <param name="charting.data1">view</param>
                          <param name="charting.data2">view</param>


Tags (1)

rizzo75
Path Finder

You have a type-o
s/columms/columns

All data sets/columns are being charted on both Y axis and Y2 axis.

0 Karma

alacercogitatus
SplunkTrust
SplunkTrust

The problem is a matter of scale. Add these:


<param name="charting.axisY2.minimumNumber">0</param>
<param name="charting.axisY2.maximumNumber">1000000000</param>
<param name="charting.axisY2.scale">log</param>
<param name="charting.chart2.axisY">@axisY2</param>
<param name="charting.chart.axisY">@axisY2</param>

These make sure that all the mins and maxes will line up, and will also present the data in "log" scale so that if the chart2 data is < 10 for example, it will still show correctly.

0 Karma

alacercogitatus
SplunkTrust
SplunkTrust

Could you pastebin the entire xml please?

0 Karma

sowings
Splunk Employee
Splunk Employee

Ordinarily, you'd be right about an issue of scale. Omitted from my list of <param>s, however, was minimumNumber and maximumNumber for the second Y axis.

That squiggly orange-red line is the requested object size on the second Y scale. So, that much is doing the right thing. It's the shadow version of that line down hugging the X-axis that has me puzzled. Three sources, four lines. Any hints?

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...