Cognos Analytics

Cognos Analytics

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

 View Only
Back to discussions
Expand all | Collapse all

Creating a calculated field to Count Distinct Duplicates

  • 1.  Creating a calculated field to Count Distinct Duplicates

    Posted Wed January 15, 2020 09:30 AM
    Hi Everyone,

    I'm pretty new to Cognos Analytics, and I am stuck on what I thought would be pretty simple. I have a column of numbers and wish to create a calculated Column to count duplication's of the same data. 

    Sample Would be:

    Application
    1234
    1234
    1234
    2456
    2456
    3590
    3590

    The calculated field would Count 1234 = 4 , 2456 = 2 , 3590 = 2 

    I have tried Count (Distinct column name) as well as a few variations, most of the time it is totaling.
    could anyone point me in the right direction? sorry if this is basic but I have only done this before in MySql

    ------------------------------
    Tracy Ballis
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Creating a calculated field to Count Distinct Duplicates

    Posted Wed January 15, 2020 10:05 AM
    Hi,

    Try this:

    Data item [Application]: aggregation set to None
    Data Item [CountApp]]: total( 1 for [Application] )


    ------------------------------
    JEAM COELHO
    ------------------------------

    Original Message