Hi,
I have data that stops in December 2018 but want to carry it through June of 2019. This is raw data I am working with. Does anyone know a way to get Tableau to show Zeroes for the months after December 2018?. The ZN function works great for months in the middle of my data missing but not for the months at the end.
Results should look like:
DepartmentsNovember 2018December 2018January 2019February 2019March 2019April 2019May 2019June 2019Test 121000000Test 235000000
The data I have lists all the information about the incidents that occur with date. Apparently there were no incidents in January - June so far. so there is no data there.
Any help would be appreciated.
Thanks,
3 answers
You'll need to create a date scaffold. Here's how: https://www.kenflerlage.com/2019/03/date-scaffold.html
