Hi,

When I create a chart, I noticed that even when enabling the "show missing values" option, if, let's say, the current time period will not show as "0" on the chart if there's no data (rows) in the table.

For example, I have this data:

Week 1: 0 rows

Week 2 3 rows

Week 3: 5

Week 4 (current): 0 rows

In my chart, only Weeks 2 and 3 will show up because the other 2 don't have any data. Is that normal or is there a workaround to make them show up?

So far I have tried to create an aggregate formula but it didn't work. Maybe my formula wasn't correct. I'm not sure.

Thanks