Yoy & PeriodOverPeriod Function in one Graph (not distinct)

[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