YOY clean visual in Quicksight

[lrromans]

I am not able to filter just the right Yr-Week for last complete Amazon week (for ex. Wk 3 23) and also to select only one column to leave YoY(Bps) Calculation is correct but cannot filter and display nicely the right one single period.https://us-east-1.quicksight.aws.amazon.com/sn/dashboards/8bc4f25f-9ddc-411f-8c36-ccc11416c2e1/sheets/8bc4f25f-9ddc-411f-8c36-ccc11416c2e1_c7232fe9-963a-4e2b-a03b-ca0a75056434?#

I am using this calculation for each metric and it is correct, the problem I have w visual display and the right filters.

difference({XXX Metric},[reportyear ASC],-1,[week])*10000

I am not able to limit the visual to one column only: for ex show only Week 3 23 values (right next to week 4 24) and YoY column only.
I had a grouping in Filters last year of: Week start Top 1 + reporting Year bottom 1; but I believed that worked because I only had 2 yrs only worth of data.

Any suggestions how to best display YoY in Quicksight is much appreciated

[ErikG]

Hi @lrromans
maybe you can have a look at.

Creating period comparisons with QuickSight's periodOver and periodTo functions

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 current date so your calculations are realistic. If you do not have a QuickSight account please follow the instructions in the Initial Setup. Instructions to create the dataset can be found in Exercise 1 of the Build your first dashboard. Create an analysis for the dataset. The following steps show you how to create visuals to show data from the current year,…

BR

[ErikG]

Hi @lrromans
could you found a solution?
BR

[lrromans]

No I would like to explore further.

I am interested in YOY when complete weeks are compared. For ex week 5 24 versus week 5 23.

Please let me know if you have a useful link.

[ErikG]

Maybe something like:

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…