When grouping data per date, sometimes some dates are missing because there is no data for it. That is expected. However, the Trend and the Time visualization do not work well with that out of the box because it compares the groups that have value.
I need to "post-process" the grouped table to fill up the missing weeks in the time frame I am interested in.
Is there a way to attach a calendar table to my grouping out of the box or do I have to write some raw SQL for it?