Supported Aggregate Functions for Reporting
The currently supported aggregation or summary functions are:
Average | Calculates the numeric average for all the values/answers for the question or field across all the forms in the Summarize-by groupings | |
Count | Returns the count of the forms (whether or not they have a value/answer for that question or field) in the Summarize-by grouping | |
Sum | Returns the numeric total of all the values/answers across all the forms in the Summarize-by groupings | |
Min | Returns the smallest value/answer across all the forms in the Summarize-by groupings | |
Max | Returns the largest value/answer across all the forms in the Summarize-by groupings |
We're continuously enhancing and adding support for additional summary functions. Please don't hesitate to contact your customer service representative with enhancement requests and ideas for additional types of summary functions and aggregations.