Visualisation Bug: Not showing figures

Dear Metabase team,

It seems that I am having a weird bug on visualization. As you can see from the graph below, I do have correct figures shown in the form, but not showing in any visualization. Can you please have a look? Thanks!
@flamber Wondering if I am supposed to tag anyone but since you solved my problem perfectly last time, I will count on you, thanks a lot!

Metabase Version: 0.33.3

13%20am
22%20am

Hi @SteveFan
That is definitely a strange behavior - looks like a bug.
Looking at the data vs chart, they don’t quite correlate. So I’m unsure how the graph is being created, meaning which settings you have adjusted?
Is this a question via the interface or Native (SQL)?
Could you supply just a couple of lines from the downloaded CSV-file, so I can try to reproduce the issue?

Hi @flamber
Thanks for the reply, it is native SQL.
However, the problem is becoming weirder…see graph below?
58%20pm

Volume number appears, but settled_date becomes empty. Weird isn’t?..

day month settled_date total_volume
2 Sep-19 2-Sep-19 20785.89977
3 Sep-19 3-Sep-19 41810.73997
4 Sep-19 4-Sep-19 75836.96848

I have not found the attachment button, so I just copy this short piece of data here.
Except the real-time volume, I have also put Target and Budget like this:

day month settled_date total_volume
2 Budget 34510
3 Budget 69020
4 Budget 103530
2 Target 77976
3 Target 155952
4 Target 233928

Thanks!

@SteveFan
Hmm…now I’m getting a bit confused - it’s late and I have been playing with kids all day, so maybe I’m tired.
The chart image and the last line on the last table matches, so now I’m not sure what the problem is…?

There’s two issues currently, which might cause some strange behavior on 0.33.3 - issue #10840 and #10862 - and it seems like those issues are specific to data containing null values, but then it shouldn’t show the chart (from what I can gather from the issue reports).

Have you tried to see if you can reproduce the issue in any way from the Sample Dataset or with plain SQL queries - that would make a huge difference and much easier to debug and fix.

Hi @flamber
Thanks for reply, do not worry too much, just take a break and have a rest.
The issue seems very unstable, that appears suddenly and disappearing without me doing anything about it. See this:
17%20pm
The real data is actually still not shown on the graph, while the Target line was not showing in the morning and shows up right now.

Thanks for reply! Have a good night
Cheers,
Steve

I’m just going to ping @paulrosenzweig to see if he can see something I might be overlooking - he has been working on a lot of the recent fixes to many of the charts.

Thanks @flamber, have a good night

Hi @flamber @paulrosenzweig

I think I have found the reason. It only appears when I set the Line Options “Replace missing values with” to “nothing”. As I changed it to “Linear interpolated” instead, the issue is gone.

Hope this might help.
Thanks.