Skip to main content

How do I report on the number of Tier 2 records associated with a Tier 1 form? (ARR)

  • February 4, 2026
  • 0 replies
  • 2 views
E
Forum|alt.badge.img

Step 1: Bring in the Record IDs for both the Tier 1 form and associated Tier 2 form

There are Tier 1 forms in this case that have multiple Tier 2s associated with it.

11475077-How_do_I_report_on_the_number_of_Tier_2_records_associated_with_a_T_2.png

 

Step 2. Add a Count() to the Tier 2 column

Select the column containing the Tier 2 Record ID, and add a Count() function via the formula bar.

11475077-How_do_I_report_on_the_number_of_Tier_2_records_associated_with_a_T_1.png

Results will then minimize the number of rows to create a single row for each Tier 1 Record ID.

11475077-How_do_I_report_on_the_number_of_Tier_2_records_associated_with_a_T.png
 
How do I count Tier 2 records for each Tier 1 record in ARR? | How do I use the Count() function in Apricot Results Reporting? | How do I show the number of associated Tier 2 forms? | How do I create one row per Tier 1 record with a Tier 2 count? | Why do I see multiple rows for one Tier 1 record in ARR? | How do I summarize Tier 2 records by Tier 1 form? | How do I report on related records in Advanced Results Reporting?
 
 

Terms & ConditionsAccessibility statement