How to use Age Groupings for Reports

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 Lookup Lists.

Setting up Age Groupings

From the Sumac console, click Utilities > Customize Database > Lookup Lists. Choose the Area: Contacts, then choose the Lookup List: 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!

    • Related Articles

    • Can Sumac integrate with Constant Contact?

      Yes, Sumac can integrate with Constant Contact. You would set up your mailing lists in Sumac to match the mailing lists you have in Constant Contact, as well as give Sumac some details about your Constant Contact account so that Sumac knows how to ...
    • 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 ...
    • Reporting in Sumac - Virtual Instructor-led Training, August 27, 2021

      NOTE: The video below shows a slightly older version of Sumac. In a recent release, we added a new Simple Search option, which is not shown in the video. To see the Advanced Search options this video explores in your own instance of Sumac, simply ...
    • 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 Lookup Lists. 1) In your Sumac console, click ...

    Contact Us