PeriodOverPeriodComparison - Desenvolvimento QuickSight

[Brett]

Hi @Gustavo_Souza and welcome to the Quick Suite Community!
Take a look at the attached documentation below, here are some old posts that explore period over period comparisons a bit further in depth. Let me know if either of these assist with your case:

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…

Period Over Period Calculations

Hello everyone! I could not figure out period over period calculations since I am pretty new. Here is my dataset: [image] Basically value equals to numerator/denominator for percentage metrics but for decimals it directly passes. So it gets complicated for me to create a WoW column for both percentage and decimal metrics. For date part I have created final_report_date column from SQL by getting first date of the week. So my dates are only showing the first day of the week. For month part I…