# Partial Period Comparison WTD WOW

**URL:** <https://community.amazonquick.com/t/partial-period-comparison-wtd-wow/17264>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [August 21, 2023, 10:35pm UTC](https://community.amazonquick.com/t/partial-period-comparison-wtd-wow/17264 "2023-08-21T22:35:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Clayton\_Barton](https://avatars.discourse-cdn.com/v4/letter/c/22d042/32.png) [@Clayton\_Barton](https://community.amazonquick.com/u/Clayton_Barton)\
**Post date:** [August 21, 2023, 10:35pm UTC](https://community.amazonquick.com/t/partial-period-comparison-wtd-wow/17264/1 "2023-08-21T22:35:00Z")

</div>

According to this [Blog Post](https://aws.amazon.com/blogs/big-data/add-comparative-and-cumulative-date-time-calculations-in-amazon-quicksight/) for Advanced Use Case 3: Partial Period Comparisons, is there a way to have this work with Week-over-Week?

For example, if today is August 16th 2023, and I want to compare my sales for the prior week’s week-to-date (not ALL of last week) how would that calculation look?

Looking for something that would take the total sales across August 6th through 9th vs the sales across August 13th - 16th. (I want to exclude August 10, 11, and 12 since today is Wednesday and I want to see how I’m trending compared to how I was the previous Wednesday)

---

<div class="post-metadata">

**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\
**Post date:** [August 23, 2023, 8:38pm UTC](https://community.amazonquick.com/t/partial-period-comparison-wtd-wow/17264/2 "2023-08-23T20:38:50Z")

</div>

"Hello Clayton\_Barton !  
For that type or calculation you would want to use [periodOverPeriodDifference,](https://docs.aws.amazon.com/quicksight/latest/user/periodOverPeriodDifference-function.html) which when using it to show on a weekly basis would look like the below example:  
`periodOverPeriodDifference(sum(Sales),{Order Date}, WEEK, 1)`

---

<div class="post-metadata">

**Author:** ![Clayton\_Barton](https://avatars.discourse-cdn.com/v4/letter/c/22d042/32.png) [@Clayton\_Barton](https://community.amazonquick.com/u/Clayton_Barton)\
**Post date:** [September 18, 2023, 10:15pm UTC](https://community.amazonquick.com/t/partial-period-comparison-wtd-wow/17264/3 "2023-09-18T22:15:07Z")

</div>

Looking for something like this: [Week to Date vs. Previous Week to Date in Tableau (WTD) — OneNumber](https://onenumber.biz/blog-1/2020/9/7/week-to-date-vs-previous-week-to-date-in-tableau-wtd)

---

<div class="post-metadata">

**Author:** ![Clayton\_Barton](https://avatars.discourse-cdn.com/v4/letter/c/22d042/32.png) [@Clayton\_Barton](https://community.amazonquick.com/u/Clayton_Barton)\
**Post date:** [September 18, 2023, 11:04pm UTC](https://community.amazonquick.com/t/partial-period-comparison-wtd-wow/17264/4 "2023-09-18T23:04:32Z")

</div>

Think I may have found a solution

WTD Sales = `ifelse(dateDiff(truncDate('WK', {date}),${Today},'WK') = 0, {Sales}, NULL)`

Prior WTD Sales = `ifelse(dateDiff(truncDate('WK', {date}),${Today},'WK') = 1 AND extract('WD', {date}) <= extract('WD', addDateTime(-1, 'DD', now())), {Sales}, NULL)`

WoW % Diff = `(sum({WTD Sales})-sum({Prior WTD Sales}))/sum({Prior WTD Sales})`

---

<div class="post-metadata">

**Author:** ![gillepa](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/gillepa/32/3891_2.png) [@gillepa](https://community.amazonquick.com/u/gillepa)\
**Post date:** [September 21, 2023, 3:02pm UTC](https://community.amazonquick.com/t/partial-period-comparison-wtd-wow/17264/5 "2023-09-21T15:02:15Z")

</div>

@Clayton_Barton  
Glad you found it!. I’ll mark your answer as a solution.  
GL