Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Counting Unique Values

James 37

Recommended Posts



I have a table collecting data on people, each with a unique ID field.


I also have a table of events, with several events for each person, related through the unique ID field.


I want to produce a report that lists some details of a set of events, devided into several sub-parts determined by values in fields belonging to the events table. Some of these events will be related to the same person. I would like my report to give a figure for the total number of events in each sub part, but also the number of unique people.


For the count of events, I simply have a summary field that displays the total count of IDs. For the count of people, I would have thought there would be a simple fuction to count the number of unique values in the ID field of the events table. Alas, I can't seem to find one. There seems to be an option for counting unique values in a portal or set of fields in one record, but not for counting unique values in fields for a set of records.


Can anyone help?

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use