Redash: Bar chart with second y axis overlaps data series

Created on 5 Feb 2018 · 14Comments · Source: getredash/redash

Issue Summary

Discussion here: https://discuss.redash.io/t/bar-chart-with-second-y-axis-overlaps/1493/3.
In a bar chart, when choosing to display a data series on the secondary y axis to the right, the data series overlaps all others:

It shouldn't. The correct solution is to display all data series side-by-side regardless of y axis.
Example from google sheets:
1 y axis

2 y axis

Occurs on v3.

Steps to Reproduce

Create bar chart with at least 2 data series
Configure 1 data series to use a secondary y axis

Any other info e.g. Why do you consider this to be a bug? What did you expect to happen instead?
I don’t think that’s the correct behaviour a secondary y axis should have. Why would anyone want a data series to entirely cover up other data series?
The objective of a secondary y axis is to allow very different ranges of values to be plotted on the same graph.

Technical details:

Redash Version: 3.0
Browser/OS: any
How did you install Redash: ubuntu provision script

Bug Frontend Visualizations Chart

Source

dncpax

All 14 comments

I have exactly the same problem.

chuckume on 3 Apr 2018

👍1

Just trying to get traction on this.
Really, a no-brainer and super-strange to explain people redash does not support such a common use-case.

dncpax on 8 Mar 2019

Seems a plotly issue to be resolve in v1.45.0:
https://github.com/plotly/plotly.js/issues/78
PR already merged: https://github.com/plotly/plotly.js/pull/3529

Example here: https://codepen.io/etpinard/pen/yZQYzq?editors=1010

dncpax on 8 Mar 2019

👍1

Ok, v1.45 is already out! They're on v1.45.2 already!

Any takers??

dncpax on 8 Mar 2019

Hi @dncpax! We're in the middle of React migration, and therefore have some blockers related to that. I think I'll take this after getredash/redash#3493 merged.

kravets-levko on 8 Mar 2019

👍1

Hi @kravets-levko thanks for the update. Been looking forward for the many great things you guys are doing.

dncpax on 8 Mar 2019

Any updates? Does not seem to be in 7.0.0.

tharapita on 18 Sep 2019

😕1

@kravets-levko
I have an angular based web app and currently exploring for dashboarding solution. Having dual axis chart is kind of a MVP requirement. Its somehow difficult to locate from the above discussions whether we can build dual Y axis as per the expected behaviour or not? Please help me point towards its implementation!