How do I show month over month data in a table, even if it is 0?

#1

I have a table that list the date in months (ex. March 2017) and the corresponding sales for that month. How do I ensure that a month (say October 2016) that has 0 sales appears as a row on the table instead of being completely omitted because it has a value of 0. Thanks!

#2

The key is to show null data points. This option is available under the measure settings within your metric set. You can see the different options detailed under the link below. Note you may need to use a time dimension and the full nulls option to get the null month to show: http://www.dundas.com/support/support-center/support-articles/data-visualizations/handling-null-data-points

#3

Figured it out with your help, thanks!