V2 Question Type: Aggregation





Aggregation questions are only used in the footer of a repeatable section. They are similar to a calculation: they are used to "aggregate" all the answers to a single question inside a repeatable section. For example, they may add all the hours together in a timesheet, or add all the "line amounts" to provide a total dollar amount for an invoice.

For information on repeatable sections: read more >

For more information on repeatable section footers:


On Mobile Devices 

Aggregations always appear in the footer of repeatable sections:

iOS Android
2017-11-14-AggregationiOS.png 2017-11-14-AggregationAndroid2.png

[ top ]


General Properties 

Allowed Data Types:form-builder-icons-v6_Number-25px.png form-builder-icons-v6_Decimal25px.png form-builder-icons-v6_Currency25px.pngduration25px.png

Allowed Restrictions: 2017-06-06-V2FB-HideOnDeviceIcon.png2017-06-06-V2FB-HideOnReportsIcon.png


Aggregation Types

You can choose to use different types of calculation in your aggregation. As follows:

  • Sum: Add all of the entries to your source question together to arrive at a total value. This is the most common aggregation type, and is often used things such as subtotals and hours-worked. In our example below, the Part Total is a sum aggregation of the Subtotal entries.
  • Count: Each entry in the source question is counted. If there are 10 entries, the Count aggregation will output '10'. In our example below, the Count Test is a count aggregation.
  • Average: Adds all the entries in your source question up and then divides them by the number of entries to create an average value. In our example below, the Average Test is the average of the Subtotal.
  • Minimum Value: Displays the lowest value entered in your source question. In our example below, the Minimum Value Test is based on the Quantity column.
  • Maximum Value: Displays the highest value entered in your source question. In our example below, the Maximum Value Test is based on the Quantity column.
  • Standard Deviation: Quantifies the amount of variance or deviation within all entries in your source question, and outputs it as a number. In our example below, the Standard Deviation Test is a standard deviation aggregation based on the Subtotal entries.



Source Question

When selecting the Source Question, please consider the following:

  • the source question must be within:
    • the repeatable section
    • a footer item in a nested repeat.
  • the data type you set for the aggregation should match the data type of the source question.


[ top ]


Properties (by Data Type)

With aggregation questions, the data type is inherited from the source question. If the entries column you are aggregating are integers, your data type should be an integer. If the entries in column you are aggregating are dollar amounts, your data type should be currency.

 form-builder-icons-v6_Number-25px.png- Integer

  • Min/Max Value: Set a minimum or maximum value allowed for this question.

form-builder-icons-v6_Decimal25px.png - Decimal

  • Min/Max Value: Set a minimum or maximum value allowed for this question.
  • Minimum/Maximum decimal places: Set the number of decimal places allowed.

form-builder-icons-v6_Currency25px.png- Currency

  • Min/Max Value: Set a minimum or maximum value allowed for this question.
  • Currency Type: Select which nation's currency type you wish to have displayed on the mobile app and reports.


duration25px.png - Duration:

  • Precision: Set the precision with which you would like to calculate a duration value:
    • Hours
    • Hours and Minutes
    • Minutes
    • Minutes and Seconds
    • Seconds

[ top ]

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request