Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Percentage Change in a dashboard

    Posted Wed January 22, 2020 08:50 AM
    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


  • 2.  RE: Percentage Change in a dashboard

    Posted Thu January 23, 2020 12:13 PM
    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-oOHE
    If 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
    ------------------------------