IBM Business Analytics

 View Only
  • 1.  Dashboad - Cumulative Sum Line/Bar Chart

    Posted 05/05/21 10:07 AM
    ​​​Hello All,
    New post, I am still learning Cognos Analytics Dashboarding. I would like to create a Line chart with cumulative total. So if the overall yearly total is 1000000,
    I would like to see how the total increased over the 12 months in the year.
    I used to use Report Studio and I used the running total function for list reports but not for charts.
    Can someone point me how I can emplement this for charts in Cognos Analytics.
    My base data is a dataset.

    Thanks in advance for your help,

    Arnold

    ------------------------------
    Arnold Ruzvidzo
    ------------------------------


  • 2.  RE: Dashboad - Cumulative Sum Line/Bar Chart

    Posted 05/17/21 04:04 PM
    Hi,
    Try making a Data Module . Create a new calculation with running total function. Then make a dashboard . Use this Data Module to create dashboard . I have not tried this personally, but I think, it should work. Give it a try & let me know.

    Thanks, Madhuri

    ------------------------------
    Madhuri gauba
    ------------------------------