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!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...