Cognos Analytics

Cognos Analytics

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

 View Only

Data module: releative date analysis with time

  • 1.  Data module: releative date analysis with time

    Posted Mon November 16, 2020 10:22 AM
    Hello,
    We have a data module that consists of historic and real time data. In that regards, I have created a relative date for today and same day last year, to compare eg. sales so far today vs last year, in a relative time data module. The issue I have is how to control the last year measure, so I compare until the time that has passed today.
    Example:
    Today is November 16th 2020 16:17:00 - and will also by the system time
    Last year measure should be November 16th 2019, until 16:17:00.

    Does anyone have any suggestion on how to achieve this?

    ------------------------------
    Sandeep Dhirad
    Elkjøp Nordic
    ------------------------------

    #CognosAnalyticswithWatson