Hi,
I have a chart that has 2 different scales so I used split y-axis. However, I can't set each y-axis label.
Does anyone know what's the workaround?
e.g. I have number of item purchased which scale in thousands and number of unique customer which scale in hundreds. I don't want the y-axis to called Number of item purchased/users on both left and right side.
Can the thousand scale one called number of item purchased and the hundred scale called number of unique customer?
Thanks
Jennifer
Hi Jennifer,
Good point! There doesn't seem to be a way to set different Y axis labels in the visualization settings. One workaround is to use custom columns in the editor and name them accordingly. Then, when you create a line chart with a split axis, those custom column names will be used. This also works with the ready-to-go column functions like "sum of ..." and "average of ..." if you're okay with those column names.
Does this chart match your needs?
As you can see, I made the question using custom columns: sum([Total]) and distinct([User ID]). The question uses data from Metabase's sample database.
Best,
Andrew
Hi Andrew,
That's exactly what I want to achieve! Let me try on mine!
Thanks
Jennifer
