Force zeros for the last x-axis values

1

I have data with some missing values. I'd like them to be zeros, especially the last values. Here is an example. I say: "View Previous 60 days" but the last point I am given is Dec, 5 despite we have already January. Could I somehow force the plot to show points with y-value equal 0 for the weeks from Dec 5 to now?

image
image2252×1670 165 KB

m

2

Hi @wmj
If you don't have any data after the 5th, then the graph will end there.
Sounds like you are looking for this:
https://github.com/metabase/metabase/issues/16153 - upvote by clicking :+1: on the first post

3

Yes. Exactly! Are there any workarounds?

4

@wmj You'll have to have a lookup table with all the dates or null rows.