Mismatched Aggregation in comparing current and previous one

[Xclipse]

Hi @rebecca000827

Welcome to the QuickSight community!

Use the lag function to compare the current value to previous value.

If you are trying the Period Over Period calculations, Please refer to the below QuickSight community post this might be helpful for you.

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…