topic Re: Two Y-axis graph: same line showing twice in Splunk Search

Two Y-axis graph: same line showing twice

sowings — Tue, 14 May 2013 02:38:48 GMT

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.

                          <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>

Re: Two Y-axis graph: same line showing twice

alacercogitatus — Tue, 14 May 2013 12:18:31 GMT

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.

Re: Two Y-axis graph: same line showing twice

sowings — Tue, 14 May 2013 18:51:41 GMT

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?

Re: Two Y-axis graph: same line showing twice

alacercogitatus — Tue, 14 May 2013 19:07:08 GMT

Could you pastebin the entire xml please?

Re: Two Y-axis graph: same line showing twice

rizzo75 — Fri, 25 Oct 2013 16:59:06 GMT

You have a type-o
s/columms/columns

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