align axis within combochart to same scale

ni_avoss — Sat, 16 Nov 2024 19:27:52 GMT

hi there,

similar to this chart in the upper right at 2:30 https://youtu.be/RkVDi0b2hmk?t=150

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

=if( max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth])) >max(aggr(Sum(Value),[Date...YearMonth])) ,max(aggr(Sum({<Version={'$(=only(RefVersion))'}>}Value),[Date...YearMonth])) ,max(aggr(Sum(Value),[Date...YearMonth])) )

which translates to: if(left axis > right axis, left axis, right axis)

but this is a very fragil approach and is also doesn't react two changes of the x-axis.

any ideas ?

thanks;

alex

Re: align axis within combochart to same scale

ni_avoss — Fri, 13 Dec 2019 14:41:51 GMT

ok, found out myself.

possible to assign it to the primary axis when line chart is selected as second measure

Re: align axis within combochart to same scale

Marcel_Garcia — Thu, 14 Jul 2022 09:01:44 GMT

topic align axis within combochart to same scale in App Development

align axis within combochart to same scale

Re: align axis within combochart to same scale

Re: align axis within combochart to same scale