Wrong column display when stacking with negative values

[grzlybear]

Issue Summary

I'm trying to create a column chart with series values that contain both positive and negative values.
For example, the number of new users is shown as positive while the number of churned users is shown as negative. They both have the same X value (same time frame).

When selecting the stacking option I expect the positive values to be above the X line and the negative values to be below the X line.

Technical details:

• Redash Version: 1.0.3
• Browser/OS: Chrome / OSX
• How did you install Redash: self hosted on google cloud

reality

expected

[deecay]

@arikfr
Introduce barmode ['stack', 'overlay', 'group', 'relative'] somewhere in the editor-ui?
Since the list of options is not too long, maybe radio control is better that dropdown, which would require more clicks. Any preference or thoughts?

Example:
https://codepen.io/etpinard/pen/mPGLrY

[arikfr]

We already have some of those options implemented with custom code, so it's nice we might be able to drop it and use their implementation.

But looks like they have a bug with "stack" too (in your example) or did I misunderstand how it supposed to work?

[deecay]

Related Plotly community discussion here.
So the behavior of "stack" seems intentional?