You should append your current data with zeroes for every month and year combination, so that the month always exists and you can do your calculations as required. If the data is from a database, you can append by doing a union.
I'll just write a custom query to inject data for nulls then, but that is a pretty big pain for my data since it is coming in from automated VBA and I have to completely re-write the vba script.
Well, you may not have an option. Anyway, appreciate if you can close this thread now.
1 of 1 people found this helpful
Hi Justin, I'm not clear on the exact calculation that's giving you trouble since you have months missing, but I think you may be able to do most of what you want in Tableau.
I created this simple table with missing months:
In Tableau, go to Analysis, Table Layout, and check Show Empty Rows and Show Empty Columns (it seems you have already got this far).
The table or chart will have blanks:
Right-click on SUM(Outages) in the Marks card, and choose Format. Put 0 in the Special Values section, you'll see that your table gets populated with 0's.
We can put Outages on the Marks card again, right-click and choose Quick Table Calculation > Running Total, and it fills in correctly for the missing months:
Or as a bar chart:
Hope this helps,