Yoy & PeriodOverPeriod Function in one Graph (not distinct)

[Annika]

We have product data available at the ASIN level with the following filters:

(Note: A single ASIN can belong to multiple product groups, meaning the assignment is not distinct.)
Marketplace

• Customer
• Brand
• ASIN

Question 1: YoY-comparison on daily base
We would like to display values for a selected Start Date – End Date range in a graph while simultaneously showing Year-over-Year (YoY) values for the corresponding start and end dates.

Question 2: Period Over Period - comparison on daily base
We would like to visualize data for a selected Start Date – End Date range in a graph while also displaying values for a custom comparison period (freely selectable).

Already tried this: Get last year value (periodOverPeriodLastValue) in a PRE_AGG scope
But the date filters will remove the comparison values in the graph

[Giridhar.Prabhu]

Hi @Annika

1. Since you want to show the value in a graph with both current and YoY values the Time Period may have to be generalized (Jan instead of Jan 2025) etc.
2. You need to compute your current Period and YoY values with date filtering within the calculated field
3. In the visual no filtering as the filtering is already done in the calculated field

The following article gives you idea for period based computations in calculated field.

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

Hi @lbl You can use the Relative Dates on the parameters (may need to make more parameters) to automatically default to a given date that represents the time period, and can use those in your table headers. It’s not as flexible as being able to write your own calculated logic, but you should be able to get most time periods represented using this (prefix each with ‘Month of’ or ‘Week of’, then put the parameter there… [image] [image]

Regards,
Giri

[Annika]

@Annika

Question 2: Period Over Period - comparison on daily base
We would like to visualize data for a selected Start Date – End Date range in a graph while also displaying values for a custom comparison period (freely selectable).

Thank you, but I can’t find the answer to my second question.
Is this even possible?

[Giridhar.Prabhu]

Hi @Annika

If you generalize the months as Jan, Feb etc you can have graph for the period selected and the comparison period, for example as two line graphs.

Regards,
Giri

[Brett]

Hi @Annika,
It’s been awhile since we last heard from you, did you have any additional questions regarding your original post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @Annika,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!