Thanks to Kettan I discovered a solution to this is to do a cross join against a source with every possible day in it, which duplicates each task for each day and makes this very easy to count.
Thanks for feedback. If I knew my link references could be used, I wouldn't have had deleted them
For those who might be interested: These are the links I referred to in the deleted comment:
I am struggling building a CFD in Tableau right now, and I can't quite follow how to execute a Cross Join to accomplish this, even following Kattan's supporting links. Would it be possible to include an example packaged Tableau workbook to help drive this answer home? Thanks!
(I apologize if this request is too long after the original post. Thanks for considering, regardless!)
Suggest you create a new post that fully explains what you are trying to do and includes your TWBX workbook - it will get you a more timely response
Good suggestion. Will do. Thanks!