IBM Business Analytics

 View Only
Expand all | Collapse all

Comparison of two trends in Cognos Dashboard

  • 1.  Comparison of two trends in Cognos Dashboard

    Posted Fri March 17, 2023 05:26 AM

    Hi all,

    We are using IBM Cognos Analytics with Watson (11.2.0).

    Currently we have date, ID, Category, Current_total_record and Last_total_record.

    The category is referring to the trend of Current_total_record and Last_total_record. 

    EG.

    For ID CU003, the trend is increasing as the current total is 60, which increasing from 59 (Last_total_record).

    Is there a way to map the category for current vs category for previous like shown in below example?

    Any help is deeply appreciated.



    ------------------------------
    Mohamad Aiman Arif Mohamat Saat
    ------------------------------