IBM Data & AI

Welcome to the idea forum for IBM Data & AI (Formerly Analytics) Clients! 


IBM Employees:

The correct URL for entering your ideas is



Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.


If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.


Problem with total on a grouped list

I have a problem in my report with a count. It's not the first time I
have encountered the problem so I'm thinking maybe I'm doing something

The data item I'm putting a count on is counted for each record of the
dataset and not only for the data item it is attached to (grouping).
I'm not quite sure how to explain the problem so I have enclosed a pdf
that explains it as well as the report specification.

If ClientA has a date for ""first contact"" it should count as 1 ""fist
contact"". But ClientA can have more that one ""project"". So If ClientA
has a date for ""first contact"" and 2 ""projects"" the count gives me 2
""first contacts"" even though there is only one displayed in the report.

Hope you can help me.
  • Guest
  • Dec 28 2018
Customer Name IBM
Role Summary
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions