I am trying to display the YearWeek dimension on the x-axis of a bar chart even if there is no data associated with a particular YearWeek value. In other words, I need to show all YearWeeks no matter whether they contain data or not.
I'm afraid there is no "simple" solution, because if have no data in some period sum() function returns 0. By default in line chart checked option "Suppress zero values". If uncheck it you will get logically right but not graceful line-chart.