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.  Group

    Posted 10/15/20 12:15 PM
    How can I create age groups for a column containing the age of users?

    ------------------------------
    Ednei Ferreira
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Group

    Posted 10/15/20 12:50 PM
    Hi Ednei,
    In Dashboarding and Web-based modeling, select the age column and from the action menu (vertical …) use the <Create data group...> entry.
    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: Group

    Posted 10/15/20 03:56 PM
    It sort of depends on what you're doing. Assuming you're talking about a report / query then you'd just create a case statement:

    case
      when [YourAgeColumn] between 0 and 5 then '0 to 5'
      when [YourAgeColumn] between 6 and 10 then '6 to 10'
      ...
      else 'OMG How Old?'
    end

    ------------------------------
    Chris Turner
    ------------------------------