Bad Y axis label/plotting on auto-scaled graph

[sunahsuh]

Eyeballing the red line, I would expect that value to be ~2.6M+, but as the hover value shows, it's actually ~1.3M. Furthermore, the value of the blue line is higher than the red line

Link to the live chart:
https://sql.telemetry.mozilla.org/queries/66136/source#167821

[jezdez]

Thanks Sunah, I've been trying to properly try to find the culprit for this, and I've so far not figured out why this is happening.

@kravets-levko Hey, do you happen to have seen such a case on your side of things?

[kravets-levko]

Hi @sunahsuh! Usually such things happen because the data is not properly aggregated. Please ensure that you have the only Y value for each X value in each series - Redash does not auto-aggregate data for visualizations (unless explicitly mentioned in docs) (cc @jezdez)

[jezdez]

@kravets-levko Thanks for chiming, this is much appreciated!

@sunahsuh I noticed DAU and SMOOTH_DAU don't have the same return type, one being an integer, the other being a float value. Could that be related?

[sunahsuh]

Hmm, the table view definitely only shows one value per day, so I don't think it's an aggregation issue.

I just tried casting the return values (both ways, both as float and both as int) and I'm still seeing the bug