Aggregating my date to Year period by week causing issues

Q&A
, ,
1

I am trying to build YoY, WoW, and YTD into a QS while creating Pivots that break down the data on a weekly basis.

I have gotten everything built out utilizing my date column for example:
YoY % = periodOverPeriodPercentDifference(sum({count}),{snapshot_day_local},‘year’, 1)

The issue is when pulling Year from a day function QS uses the normal calendar year but our weeks run Saturday through Sunday. This causes the data to be wrong on the first week of the year since it runs December 29th-Jan 1st. How can I get this week 1 to work?

2

Hi @chazcarl ,

Welcome to the Quick Sight Community!

You can set the week start day as part of the analysis settings.

image
image308×768 27.2 KB

Check if configuring the start of the week day resolves the Week 1 discrepancy.

Thanks,
Prantika

3

Hi @chazcarl,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!