Counting the number of object records in a report
HandsOn Connect has hidden fields that allow you to easily count the number of objects in a report.
There are "number of" fields for:
- Number of Contacts
- Number of Organizations
- Number of Connections
- Number of Occurrences
- Number of Volunteer Opportunities
For example, in a report that shows all the occurrences that took place in a given time period, you could group the occurrences by the volunteer opportunity name -- but what if you wanted to know how many volunteer opportunities that represented?
In this report we have grouped based on Volunteer Opportunity Name -- but we want to know how many volunteer opportunities this represents - without manually counting them.
We are going to show details and add the field "Number of Volunteer Opportunities"
Each object in HandsOn Connect has a field called "Number of...." that has a value of 1 populated in it.
By summing these "Number of" numeric fields - we're able to get a count.
First -- add the field "Number of Volunteer Opportunities" to your report: (you can double click and add it to the end of the report)
You'll see it has a value of 1 (1 for each occurrence)
Summarize on this field and get the sum
At the bottom of the report, you'll get the sum of the number of volunteer opportunities
This report has 1267 Records (Occurrences), and 135 separate volunteer opportunities.
0 Comments
Add your comment