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!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...