Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Add Series Total on Point Chart

    Posted 05/29/19 12:25 PM
    Hello,

    Is there any way to add the total for all series on a point chart?

    For context, say I have years on the x-axis, dollar amounts on the y-axis, and with a series of categories (let's call them units). As of now, I have the values for each unit, for each year, graphed. Is there a way to add the total for all units for each year? 

    Example: in a given year, say 2020, I have unit A forecasting $5, unit B forecasting $3 and Unit C forecasting $7, I want a Unit Total point showing $15.

    Thank you!

    ------------------------------
    SP
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Add Series Total on Point Chart

    Posted 05/29/19 12:53 PM
    @Sahil Patel You can do this using a union query. I've attached a sample report spec and screenshot of the output.​​

    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Attachment(s)



  • 3.  RE: Add Series Total on Point Chart

    Posted 05/29/19 12:55 PM
    Thank you Denny! I ended up doing something similar.

    ------------------------------
    Sahil Patel
    ------------------------------