Second Y axis


#1

I have two series in my query and I’d like to be able to plot them on separate Y axes (but on the same chart). Is this possible?


#2

Is this a GUI query or SQL?

Currently we allow multiple series ala http://www.metabase.com/docs/v0.16.1/users-guide/09-multi-series-charting.html


#3

I have both. I’m able to get multiple series on the chart without problems, but one has values that are several orders of magnitude higher than the other, so I’d like to have Series A plotted on the Left-Y axis, and Series B plotted on the Right-Y axis.

As far as I can see this isn’t possible though, right?


#4

With multiple series that come from different queries, we will break up the axis for you. Can you screen shot what you see? Perhaps using a similar query against our sample dataset if you can’t share numbers or trends.


#5

I’m not explaining this clearly. Consider this SQL query from the sample dataset:

select day_of_month(created_at), sum(subtotal),avg(subtotal)
from orders
group by day_of_month(created_at)

This makes a chart that looks like the first below.
However, I want the green line to be on a separate Y axis - the second image shows what can be done with the same raw data in excel (average is on the right-hand axis):

Does this make sense?


#6

any update on this?


#7

I’m not sure when the feature was added but I can see v0.26.1 can have 2 different Y-axes for different sets of data. The new issue that arises is that the labels for those axes are shared. The first query will be used unless overridden in the graph’s settings.

Even in v0.28.1, the axes labels are shared. We now have the ability to update the labels for each series in the graph, but we are not able to update each label for the Y-axes yet.