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!

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer at Splunk .conf24 ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

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

Combine Multiline Logs into a Single Event with SOCK: a Step-by-Step Guide for ...

Combine multiline logs into a single event with SOCK - a step-by-step guide for newbies Olga Malita The ...