Custom Aggregate Functions will be available in any formula editor in which the existing built-in aggregate functions are also available.

Our Vice President of Client Experience Travis McGrath introduces Custom Aggregate Functions, and walks through two examples writing them.

All built-in functions are listed here.

Returns a concatenated string of values separated by a specified delimiter string.

Returns the count of values of dataToAggregate with a corresponding true condition. Only those records with a true condition are included in the count.

Returns the average of only unique values in a series of values.

Returns the sum of only unique values in a series.

Returns the sum of values of dataToAggregate with a corresponding truecondition.

Returns the corresponding correspondingValue associated with the maximum value of maximizedValue.

Returns the corresponding correspondingValue associated with the minimum value of minimizedValue.

When updating Exago, consult this guide for potential breaking changes.

When building configuration files without the Admin Console, or to change settings in the API, use this reference to map Admin Console General settings to the relevant config file node or API key.

Aggregating leverages the power of ExpressView groups to compile summaries of data. Aggregates may be optionally added for each group and for the entire report.

Incremental loading limits the amount of data that is returned for each database query. This allows users to load reports incrementally, starting with a small set of rows and adding more in steps as desired. Incremental loading can shorten the amount of time it takes a report to load and be usable. It can also help reduce continuous load on a database which may improve load balancing performance.

To show only data that matches certain criteria, filters can be added. Filters can also improve performance by only including relevant information. There are two kinds of filters that may be applied to an ExpressView: Standard and Top/Bottom.

ExpressView is a report building tool that combines grouping, sorting, filtering, and summarizing data with a drag-and-drop interface. A chart can be added with a single click, and the entire report can be exported as PDF, RTF, CSV, or an Excel workbook.