Cognos Analytics

 View Only
  • 1.  Week to Week comparison in report

    Posted Fri August 23, 2019 12:28 PM


     In the below table, I want  A, B , C and D data to get refresh every week from flat excel file and  W2W comparison with the previous week data. What will be the formula to do W2W comparison.I have appended the both the weeks file with adding the date column.

    Cognos query

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

    Original Message


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

    #CognosAnalyticswithWatson


  • 2.  RE: Week to Week comparison in report

    Posted Fri August 23, 2019 02:42 PM
    Have you tried a running-difference formula?​

    ------------------------------
    Jenifer Broughton
    ------------------------------