I want to create a combo chart with a metric on the left and another target metric using lines and the right axis. as seen in the video, this doesn't make sense if those two axis don't align and share the same scaling.
so is there a smart solution to align those two ? automatic scaling works good for a single axis, but not for both
I came up with calculating the scale limits for both like