Incorrect Pivot Table Aggregation from Day to Week

Question & Answer
,
1

Hi team, I’m using a pivot table to aggregate the sum of hours by month, and was seeing discrepancies in what was expected. When I changed the date aggregation to “Day” the data was correct, but isn’t getting rolled up into Month correctly.
As seen below, 12/11, 12/7 and 12/6 should all be included in Week of 12/11 (28 + 8 + 4) but the weekly aggregation for 12/11 only shows 28.
Same for 12/4, 12/2, and 12/1 (14 + 24 + 2) but Week of 12/4 only shows 26 hours.

Any ideas on how to fix this? Thanks!
image
image

2

Weeks in quicksight start on Sundays. Do you want them to start on Mondays?

You can look to this post for that.