Weekly Data Not Aggregating Properly

Question & Answer
,
1

Hello all,

I have a QuickSight dashboard where I am trying to show the weekly data on some metrics.

I am trying to aggregate the data on a weekly level, but it appears that the dashboard is confused between what to consider Sunday as the previous week or current week, resulting in 2 row entries per week. How can I fix this so that it just reports one datapoint per week? I have posted a snapshot below.

Thanks in advance!
image

2

Hi @yipk, QuickSight is grouping the data by Fiscal Week and Day, so it looks as though maybe your calculation for Fiscal Week is causing an overlap. What does that calculated field look like?