In my below example, I have two open issues. Their original due date is when the issue to get close. For some reason, they revised the closure date in future.
For the issue#1, 4/30/2018 < 6/30/2018 then I need to add the counters from the reporting month until Actual Closure Date satisfies. Then use the "total Count" to plot the line graph.
To achieve your requirement, you need to join your data to a calendar table as shown below
I attached the workbook for your reference.
Hope this helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...