Hi @darresmi,
So are your calculated fields gathering the correct information for other dates, and it’s just the 14th that isn’t working? Or are you not using those calculated fields?
Are you applying any filters to the pivot table that may be limiting your return? Looking at your pivot table, it looks like it’s showing dates that have comment_check_weekly returning a 0 so if the 14th is returning 1, that may be why it’s not showing up.
This may be easier to diagnose further if you are able to create a sample analysis in the QuickSight Arena.
If not, could you provide some additional screenshots so that we can try and learn a bit more on why this may be occurring.