'Replace missing values with' broken in v0.33

Bug reports
1

I have a line chart where the y-axis values are null for some dates. When the default 'linear interpolated' is selected, the line chart renders as expected. Selecting either of the other to options no longer works correctly however.

Compare the same chart below where 'Replace missing values with' is set to 'Linear Interpolated' and 'Zero'

image
image1017×712 88.8 KB

In this case, the expected behaviour is that the last point would not render (as it's a null) rather than the entire series be zero.

This exact chart worked in previous releases so this appears to be a bug that's been introduced.

2

Hi @nick_at
There has been several issues fixed since 0.33.0 - could you check if 0.33.2 works?
Otherwise it would be great to have steps to reproduce, so it’s easier to create an issue for it.

3

Hey @flamber. We've just upgraded to 0.33.2. I've managed to replicate the issue with some dummy data. The issue appears to exist when the x-axis is a date. When you change it to an integer it works fine.

The below syntax is for a MySQL database:

SELECT '2019-01-01T00:00:00.000Z' AS date,0.67567 AS val1
UNION ALL
SELECT '2019-02-01T00:00:00.000Z' AS date,0.345634567 AS val1
UNION ALL
SELECT '2019-03-01T00:00:00.000Z' AS date,0.24574257 AS val1
UNION ALL
SELECT '2019-04-01T00:00:00.000Z' AS date,0.3462346 AS val1
UNION ALL
SELECT '2019-05-01T00:00:00.000Z' AS date,0.346456 AS val1
UNION ALL
SELECT '2019-06-01T00:00:00.000Z' AS date,0.3457451
UNION ALL
SELECT '2019-07-01T00:00:00.000Z' AS date,0.3463456 AS val1
UNION ALL
SELECT '2019-08-01T00:00:00.000Z' AS date,NULL AS val1

image
image3256×898 107 KB

4

@nick_at
Okay, so I’m fairly sure you’re seeing an oldie-but-goodie issue. If you go to the Axis-tab and change “X-axis scale” from “Timescale” to “Ordinal”, then that should solve “fix” it.
Go and upvote the issue by clicking :+1: on the first post:
https://github.com/metabase/metabase/issues/4802
Or maybe you’re seeing this (sorry it’s late, I’m tired):
https://github.com/metabase/metabase/issues/4122

5

Thanks for the support on this! Changing to ordinal worked and have voted on this issue which appears to be the same: