Configure 2 y-axis to be dynamically proportional to each other
I have a line graph with 2 y-axis. I need the right axis to be proportional to the left axis 1:7. But I cannot use Static Max settings, as the max values change when filtering.
Use max(aggr()) function on the first expression for each of the dimensions. Make a variable out of this and use it as max value for the expression. For the second expression use 7*variable as max value.
