Thanks. Can you please tell how you fixed it. How it is showing missing date values when the dates are not in sourcee. Does Tableau fills up dates intrinsically based on element data type.
I've just flagged the Show Missing Values on the Date pill.
This enforces padding the dates (a kind of data densification),
so the additional (densified) Marks are drawn for the missing dates
(inside the range of dates from the datasource, of course).
Besides, I've modified the [hours] calc a little bit --
to accommodate for the 3-digit hour number in the Grant Total.