Is it possible to have 2 visualizations on the one report where their Y axis scales are aligned?
I have 2 sets of data that work off filters joined via Dim tables, so both filter at once dependant on the selection.
If i leave the Y axis scale to Auto, then the 2 reports scale differently dependant on the data (eg one will scale to 800 and the other to 1200 as the data has different max figures.
If I set a pre determined max figure on both charts they will align, however as I filter down then the chart only shows a very small part of the overall chart space (eg Total hours are 20000, filter down and the data is only 500 hours, so is a tiny bump at the bottom of the chart space as the Y axis is still showing 20000)
I would like both Y axis to match, but change dynamically for best display of the data (ie the max value is set from the max of both charts, and both are scaled accordingly)