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.  Adding a second global summary column in a CrossTab

    Posted 11/18/20 08:24 AM
    Hello community,

    In a crosstab I wish to have two global summary columns (on the far right). The first summary column works, the seconds doesn't. 

    Here is the problem:
    The cross tab has a main measure - "Anzahl Tickets", which is used in the global summary column (average - Ø) on the right.

    In order to add that column I clicked on the top time-measure (DDAT_ISO_KW) and chose the average summary.
    As "Anzahl Tickets" is the main measure in the CrossTab, the summary columns refers automatically to this column's data.
    As a result, the name of this column is "Average(DDAT_ISO_KW)".
    So far so good.

    The problem starts when I wish to have another global summary column on the far right - that uses the measure "Prozent Tickets".
    Whenever I add another global summary column it refers automatically to "Anzahl Tickets", because this is the default measure of the CrossTab.

    What I don't need is this:


    because the aggregation is not global (doesn't aggregate on the "DDAT_ISO_KW" level).

    Any idea of how to add add another global aggregation that refers to "Prozent Tickets" and not to "Anzahl Tickets"?

    Thank you.


    ------------------------------
    Ori
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Adding a second global summary column in a CrossTab

    Posted 11/18/20 10:01 AM
    Hi Ori,

    I hope I understand what you mean. But you could create two query data items:

    aggregate ( [#Anzahl Tickets] for [DDAT_ISO_KW] )
    and set the detail aggregation op average

    aggregate ( [Prozent Tickets] for [DDAT_ISO_KW] )
    and set the detail aggregation op average

    Then add these two items to the crosstab.

    ------------------------------
    Thomas van der Meer
    ------------------------------



Related Content