"Yesterday" and "Previous day" in Pulse inaccurate

1

Today is 14 September.

I have a question with the following output:

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

Screen Shot 2016-09-14 at 10.36.14 PM.png816×262 10.4 KB

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.

2

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.