Summarize, Groups and Aggregates

OpenRoads Designer provides Summarize and Groups and Aggregates in report definition properties. You can summarize information in desired columns to view the summation at the bottom of the report preview and in the report table once placed in a model. You can group similar entries in a column and generate aggregated information like sum, count, average, minimum and maximum for values corresponding to them.

You can access these from the following:

Ribbon:Drawing > Analyze > Reports > Reports dialog
Ribbon:Modeling > Analyze > Reports > Reports dialog

Setting	Description
Groups and Aggregates	Columns options - Allows you to select an action from: Groups and Aggregates - will show groups as well as aggregation information in the report. Aggregates - will only show aggregation information in the report. All - will show columns, groups and aggregation information in the report.
Summarize	Summary row - Allows you to choose to Show or Hide the summary in a report.

Groups and Aggregates

Used to group similar entries in a column and generate aggregated information like sum, count, average, minimum and maximum for values corresponding to them. You should define both groups and aggregates to achieve desired results.

Setting	Description
Groups	Allows you to group columns: Add/Remove drop-down - add or remove columns to group Group By - shows the selected columns that will be grouped
Aggregates > toolbar	Lists the following: Select all - selects all added columns. Clear all - deselects any selected columns. Add rule - lets you add rules. Delete rule - deletes a selected rule. Sort ascending - arranges rules in alphabetical order A to Z. Sort Descending - arranges rules in reverse alphabetical order Z to A. Search - lets you search for a rule by name.
Properties > rules list	Checkbox - allows you to select or deselect a rule. Allows you to select a column. Drop -down button shows available columns. Sum drop-down menu - lets you select a method from: Sum Count Average Min Max removes respective rule from list.

Summarize

Used to summarize information in desired columns and view the summation at the bottom of the report.

Setting	Description
Properties > toolbar	Lists the following: Select all - selects all added columns. Clear all - deselects any selected columns. Add rule - lets you add rules. Delete rule - removes aggregation rule Sort ascending - arranges rules in alphabetical order A to Z. Sort Descending - arranges rules in reverse alphabetical order Z to A. Search - lets you search for a rule by name.
Properties > rules list	Checkbox - allows you to select or deselect a rule. Allows you to select a column. Drop-down button shows available columns. Sum drop-down menu - lets you select a method from: Sum Count Average Min Max Note: For columns with data type "string" only "Count" operation is available. For data type "numeric", it will show all the above operations. removes respective rule from list.