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