Y-axis is mislabeled / data is misleading

[mreid-moz]

Issue Summary

In a stacked bar graph, the Y-axis labels do not match the actual data values, resulting in a visualization that is incorrect (too high) by an order of magnitude.

Steps to Reproduce

1. Visit this example graph
2. Un-select everything but the "ROW" series
3. Observe the scale on the Y-axis compared to the hover-over value (or compare with the "table" view of the data)
4. See that the Y-axis shows the data ~10x larger than it really is.

[rafrombrc]

Similar in some ways to #334, these should both be kept in mind when digging in to this code.

[emtwo]

Dug into this a bit and noticed that if the x-axis scale is changed from Category to Datetime this issue disappears.

[emtwo]

This issue seems to be resolved upstream. Here is an example of a simplified query that reproduces the issue:

https://sql.telemetry.mozilla.org/queries/52016#138869

Running this query:

WITH sample as (
    select '2018-02-18' as x, 'US' as type, 574047 as foo union
    select '2018-02-18' as x, 'ROW' as type, 8215767 as foo)
select * from sample

The issue is still reproducible on http://demo.redash.io but not with a fresh checkout of this repo.

[rafrombrc]

Seems to be resolved by upgrading plotly dependency.

[mreid-moz]

I'm still seeing this issue in the query linked in the initial summary - do you know when a fix will be deployed?

[rafrombrc]

Yes, sorry... 'closed' means the fix is merged and deployed on staging, ready for confirmation (or not) by QA. We might see this pushed to prod this week, but more likely will be next week.

[mreid-moz]

Cool, thanks!

[madalincm]

Verified as fixed in FF59(Win7) in stmo-stage
Postfix screencast:

Marking bug as verified fixed.