Hi Francesco,
The best approach is to follow the approach that I mention in this post:
https://www.linkedin.com/posts/avaldez3_how-to-calculate-relative-time-measures-activity-6625827931010801666-oOHEIf you can solve the logic required to get your conditional measures, then calculating the % differences between these items should be pretty simple.
Feel free to reach out if you want to do a quick screen share.
BTW - as to your second requirement, which I am interpreting as basing the reference period on a parameter (you mention "filter"), this will be very straightforward in Reporting, but no so much in Dashboarding
------------------------------
Albert Valdez
albert@intelalytics.com------------------------------
Original Message:
Sent: Wed January 22, 2020 03:24 AM
From: Francesco Lastrino
Subject: Percentage Change in a dashboard
Hi all, I have a question. How can I calculate the percentage change between two years, year-to-date and prior-year-to-date, without using the relative time and _as_of_date? I would like to change the reference period dynamically based on a filter. Thanks
#CognosAnalyticswithWatson