So helpful. Thanks, Dimitri. Worked like a charm.
Dimitri Blyumin (or any other member of the Forums), followup question that you may be able to resolve that I came up with after implementing your solution above. In my real-life case, I didn't have any events take place during Q1, so when I run through your protocol of showing missing values, Q1 does not appear.
Do you have any recommendations to solve that problem?
Looks like your data starts with Q2.
Tableau, understandably, only fills the blanks for missing data within the data date range.
In your case the simplest thing to do is to pad your data with some 'fake' records from Q1 indicating that nothing happened then.
If you can't change your data source, then you can try making an Excel file with a frame table that will contain all the dates you want, including Q1, and using that 'frame' it in the same workbook via data blending, to pad your data. This may or may not work, but I can promise the data blending will give you some grief regardless of outcome.
I can't seem to get this to work in v9.
I have specified in format to show nulls as '0' and 'Show at Indicator', but nothing appears. The 'Show Missing Values' option does not appear as a selection when I right-click on the label.
Have these features changed since release of v9?