Need help to replicate Year over Year - when KPI is a calculated field

  1. Create a parameter with string data type and a control based on it:

  2. Create a field for period “Granularity”:

  3. Create a KPI with “Granularity” in Trending group and your metric in value:

  4. Create another filter for picking up a date:

You will get what you want. Enjoy it. The demo central might implement in another way. But with my solution you should be able to get what you want.

2 Likes