Cognos Analytics

 View Only

  • 1.  Group

    Posted Thu October 15, 2020 12:15 PM
    How can I create age groups for a column containing the age of users?

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

    #CognosAnalyticswithWatson


  • 2.  RE: Group

    Posted Thu October 15, 2020 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
    ------------------------------

    Original Message


  • 3.  RE: Group

    Posted Thu October 15, 2020 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
    ------------------------------

    Original Message