Cognos Analytics

 View Only
  • 1.  YOY growth trend in Visulization

    Posted Tue January 07, 2020 06:29 AM
    Hi

     Have a base file in which I have revenue numbers for past 12 qtrs. I am trying to create a graphs showing historical trend YOY and QOQ growth.

    In Cross tab and list I can add the formula and create the same. But not sure how to do same in graphical view ( Bar chart showing revenue by qtr and line graph showing YOY growth.



    ------------------------------
    MONA KEDIA
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: YOY growth trend in Visulization

    Posted Wed January 08, 2020 09:52 AM
    Have you created a data module for the file that you are using?

    If you have a data module you can apply a relative date calculation to your data and measures.  The calculations are applied and you don't have calculate for each query or dashboard, you just drag the fields into the list, crosstab or visualization.

    https://www.youtube.com/watch?v=4lDrF3jx98g

    ------------------------------
    Jo Marie Sellner
    ------------------------------



  • 3.  RE: YOY growth trend in Visulization

    Posted Wed January 08, 2020 07:23 PM
    Hello,

    If FM is no go, then you can use the hack to create datasets using below URL and then create your dashboard using the datasets. 

    http://cognospaul.com/2018/08/09/hacking-datasets-everything-ibm-doesnt-want-know/#comment-23456

    ------------------------------
    satish attili
    ------------------------------