topic Re: Multi series column chart with overlay separate y-axis in Dashboards & Visualizations

Multi series column chart with overlay separate y-axis

nirmalya2006 — Thu, 11 Aug 2016 14:20:55 GMT

Hi All

I am trying to create a multiseries column chart over time with two different y-axis - one on left and one on right.
My Basic query is as below :

| stats avg(eval(iBatchSize/1024)) as Avg, avg(iDocCount) as Count by _time

What I am trying to achieve is to create column chart as below
The blue columns to show average batch size and the red columns to show document count.
They will come in pairs for a span=1d.
Blue columns will have the y-axis on the left side of the chart and red columns on the right.
This is because the values cannot be brought on the same scale.

I want to know if this can at all be done.
If so, please guide me.

Thanks in advance

Re: Multi series column chart with overlay separate y-axis

sundareshr — Thu, 11 Aug 2016 14:23:50 GMT

Have you looked at overlay?

http://docs.splunk.com/Documentation/Splunk/6.4.2/Viz/Chartcontrols#Chart_overlay_example_.28dual_axis.29

Re: Multi series column chart with overlay separate y-axis

jkat54 — Thu, 11 Aug 2016 14:38:44 GMT

Converted to answer because chart overlays will do exactly what the requester is asking for.

Re: Multi series column chart with overlay separate y-axis

sundareshr — Thu, 11 Aug 2016 15:10:29 GMT

@nirmalaya2006 The overlay field in a chart can only be set as a line. You cannot set it as a column.

Re: Multi series column chart with overlay separate y-axis

nirmalya2006 — Thu, 11 Aug 2016 15:39:47 GMT

Thant is exactly where I am stuck.

Chart overlay cannot show double columns.
I need to implement a multi series chart but I am unable to do so.

Please help me to get this working.

Re: Multi series column chart with overlay separate y-axis

sundareshr — Thu, 11 Aug 2016 16:47:39 GMT

I am not aware of a way this can be achieved. Besides, not sure if it is the best format - having two column next to each other with differing scale.