How to use Age Groupings for Reports
Age groupings tell Sumac how to group contacts by age when performing a Quick Count report in the Contact list. This is incredibly useful any time you need to pull a report that groups your contacts by age (e.g. reporting to a funder on the age ranges of your clients).
To use Age Groupings, your Sumac Administrator must define your Age Groupings in Field Values.
Setting up Age Groupings
From the Sumac console, click Utilities > Customize Database > Field Values. Choose the Area: Contacts, then choose the Field Values: Age Groupings. Click New to add a new Age Grouping:
You can set up to 10 age ranges per grouping. Each age range requires a minimum and maximum age.After you've defined your Age Grouping, click OK to save it. Continue this process for any Age Groupings you want to use when reporting on contacts.
Once defined, these Age Groupings can be used in Quick Count reports.
Reporting on Age Groupings
For example, if you were reporting on Age Groupings from your Contact List, expand the Analyze & Report menu, and click Age Groupings. Drag the "Age Grouping" option from the Available Fields on the left, over to the Fields to Show on the right.
Select the Age Grouping you want to use for this report, as well as an Effectivity Date.
Effectivity Date is flexible, so if you are running an Age Grouping report and want your contacts ages to be calculated based on the start of the previous month, adjust the Effectivity Date accordingly, and Sumac will use that date when calculating which contacts belong in each age range.
Alternatively, perhaps you want to see a projection of Age Groupings for next year. Adjust the Effectivity Date accordingly, and Sumac will calculate your contacts ages for a future date.
Click OK and Sumac will produce the Age Grouping report for you!
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Reporting in Sumac Case Management for Hospices
Sumac has many built-in reports, as well as precise searching and flexible export options to customize your reporting. Using search and export for custom ad-hoc reporting This article tells you how to search using the search panel. You can also ...Clickable links in reports & show contacts
Many Sumac reports now have clickable links to records and a Show Contact(s) button that will open a search window listing all Contacts in the report. An example of this new feature can be found in the donations area. To see an example, navigate to ...Basic Concepts and Built-in Reports
Basic Concepts and Built-in Reports There are two approaches to reporting in Sumac: Sumac's built-in reports, or Custom Reports The reports are found in distinct area of the Sumac database. In this article, we'll explore built-in reports. Run ...Reporting in Sumac Case Management for Health and Social Services
Sumac has many built-in reports, as well as precise searching and flexible export options to customize your reporting. Using search and export for custom ad-hoc reporting This article tells you how to search using the search panel. You can also ...How to Set up Constant Contact Integration in Sumac
In order for Sumac to export email addresses over to Constant Contact, you need to give Sumac some information about your Constant Contact account so that Sumac knows how to do this. This is set up in Field Values. 1) In your Sumac console, click ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.