"Yesterday" and "Previous day" in Pulse inaccurate

Today is 14 September.

I have a question with the following output:

When I add this question to a Pulse, it produces the following:

While "Yesterday" = 1 seems correct, "Previous day" = 1 seems incorrect, because the previous day from yesterday would be 12 September which has a value of 0 in the question.

I think the problem here is that you don’t actually have a row for September 12 in your results.

Metabase doesn’t fill in these blank spots, it is assuming that your data is complete.