This article uses the SaaS-Sales Dataset that you can download as part of the Quick Sight Author Workshop . We will update the data to the current date so your calculations are realistic. If you do not have a Quick Sight account please follow the instructions in the Initial Setup. Instructions to cr…

Hi, @Steph . Thanks for the followup. The purpose of the periodOverPeriodLastValue calculation was to create a symmetrical runningSum comparison month-over-month-over-month, said another way comparing the same number of days in each period. In your example, taking it one step further by having anothe…

@Steph Thanks for sharing the details. It is really helpful. However, I am wondering if the same logic can be used for comparing a field (string) across two different dates? For example, in IT landscape, on 01 Jan 2023, RDS instance type for instance ID A was “t3.medium” and on 07 Jan 2023 the RDS i…

Hi @AadiG Since the comparison is between measures, these would need to be numeric. I created an example for you which you could use though as follows: My dataset looks like this Date,InstanceName 2023-01-01,t3.small 2023-01-02,t3.medium 2023-01-03,t3.medium 2023-01-04,t3.small 2023-01-05,t3.small…

Dear @Steph , I am also trying to get better visibility of an orderbook and your example is super helpful. I am - on top of the YoY comparison trying to solve another problem: My datastructure looks like this: Quantity ordered, Order date, Delivery date, Order status To give a realistic view on the…

Hi @Steph , it’s a good sample, very useful, thank you! Here is a question: can I use variables (field) as an offset parameter in periodOverPeriod functions? I see I can use Parameter there, but when I try to use field - I receive error message: periodOverPeriodPercentDifference(ACoSbyTime,{time_wi…

Hey @Steph , this is super helpful. Thank you for putting this together. I would like to add ‘Week’ as a time period control and I can successfully add it to the controls and I see that the Date (Period) field in the table visual updates to show weeks instead of days/months/quarters but my Previous …

Hi @daylightfinisher - I thin kin this case you need to get both date fields into the same column in order to plot them on the same X-axis. Best way to do this is to UNION the table with itself, and in the process align the date fields into the same field, and introduce a new field that describes wh…

Hi @joeyu629 - see step 10 in the original article. This shows how to turn a date filter into a date ‘hider’ that will keep the previous year data in the query, but will hide it from your visual. Also a similar version of this solution showcased here: https://democentral.learnquicksight.online/#D…

Hi @Mykhailo_Sorochev1 - not 100% sure on this one. You are saying using a parameter as the offset value works, but using a real field does not? If so, it could be that since this calculation is working across many rows of data, the value of that field might be different in those rows, and QS doesn…

Creating period comparisons with Quick Sight's periodOver and periodTo functions

Learn Technical Articles

Kristin May 5, 2023, 10:18pm 9

@Jesse Any thoughts on this?

YoY Monthly/Quarterly Growth Graph in QS

Topic		Replies	Views
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	38585	November 24, 2025
PeriodOverPeriodComparison - Desenvolvimento QuickSight Q&A analysis , error , quick-sight , dashboard , calculations , Business-Intelligence-Engineer	2	52	November 19, 2025
YOY data with pre-set date range filters Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	16	266	August 22, 2024
Month to Month comparison from this year to previous year Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	568	January 18, 2024
Create a KPI visual that compares to the previous period Q&A period-over-period , feature-request , quick-sight , Business-Intelligence-Engineer , kpi	4	1060	October 14, 2024

Creating period comparisons with Quick Sight's periodOver and periodTo functions

Related topics