Hi, I am new to quick sight and i have below problem to solve, could you please help. I have an order date and order count columns, i want to plot this to a vertical bar chart. And in each bar i want to show the aggregation of order counts in current week, same week in last month and same week in l…

Hi @Ren maybe you can have a look at: [image] Creating period comparisons with QuickSight's periodOver and periodTo functions Articles This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop . We will update the data to the …

@ErikG thanks for the reply. I already tried the method in first link It works for me in case of day, I can plot current day, same day in last week and same day in last month using below formulas PeriodOverPeriodLastValue(sum({order_count}), {Date (Period)}, WEEK, 1) PeriodOverPeriodLastValue(su…

Any help on the above issue is very much appreciable, since I am stuck here.

@Ren - This should get you same week last year: periodOverPeriodLastValue(sum(Sales), {Order Date},WEEK, 52) Not sure how you want to calculate same week last month, but if you want to go 4 weeks back you could do this: periodOverPeriodLastValue(sum(Sales), {Order Date},WEEK, 4)

@Kellie_Burton thanks for the reply I could do the year case as you mentioned. But in case of week, for example if it is 2nd week of current month I want to compare it with last month 2nd week. If there is no such week number in last month, get the data of last week.

HI @Ren would you like to compare the second week of the last month or the week of the last month of the date? e.g. week 11 = is March 11 would you compare with the week of Feb 11 or week 7? BR

Sorry for the late reply Yes Erik, we want to use the week of Feb 11 for comparison (week 7 in 2024)

Hello @Ren , @ErikG , and @Kellie_Burton ! @Ren are you still working on this problem or were you able to find a solution? If you were able to find a solution could you share it to help the community! In the past when I have had trouble using the periodoverPeriod functions I have used conditional s…

Hi @Ren , It’s been awhile since we last heard from you. Were you able to work out a solution for your original request or are you still having issues? If you were able to solve, please share with the community what worked for you. If you are still in need of assistance, let us know and we can try …

We were working on this issue as part of a feasibility to use quick sight in our web application. Anyway without solving this issue completely, we decided to use it, so once the development starts we may start to work on this issue again. But currently we can close this issue. Thanks for your help

Compare current week, same week in last month and same week in last year

Q&A

ErikG February 8, 2024, 3:58pm 2

Hi @Ren
maybe you can have a look at:

and

Topic		Replies	Views
Last x Weeks compared to same periods PY Q&A analysis , date , period-over-period , quick-sight , visuals , Business-Intelligence-Engineer	9	309	January 24, 2024
Comparison of values for different time periods (EX. week 1 june 2023 compared to week 1 june 2024) Q&A analysis , period-over-period , quick-sight , calculations , Business-Intelligence-Engineer	6	333	June 28, 2024
Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc) Technical Articles yoy , date , period-over-period , quick-sight , calculations , Business-Intelligence-Engineer	103	38123	November 24, 2025
Period Over Period Comparison Bar Chart Q&A analysis , quick-sight	4	1020	November 21, 2023
Creating period comparisons with Quick Sight's periodOver and periodTo functions Technical Articles error , calculations	32	25298	November 21, 2024

Compare current week, same week in last month and same week in last year

Related topics