What is the best way to use the Stacked Column and Line Chart for customers while getting the left/right axis to behave?
Right now, I have a dashboard using that visualization type in Incorta, but the left/right y axis seem to have minds of their own. The data we are looking at can range between 10,000 to 100,000 or even millions of dollars in the same time frame, and the two axis will struggle to display the data.
I absolutely need the trend line over the column charts, and this is the only option incorta's visualization tool has for that need.
However, even if I "lock down" the left/right axis with the same hard-coded number limit, i may toggle to a different project/source data that has a completely different range. Think large project in millions, or small project in thousands. So "locking" the axis range is not sustainable if you switch projects
Even if I limit the axis to say 6,000,000, the display will still show $6 million on the left axis, but $6.2 million on the right axis. Super frustrating.
I am looking for a way to have it auto-adjust to the axis to best fit whatever data its showing.
Let me know your thoughts!
Respectfully,
David M
