IMOS On-Prem - Adding Aggregate Functions

You can use an aggregate function in the Report Designer to average, count, sum, or perform another function on column data. You can do very powerful comparisons and find out true performance values. For example, you might want to find the average return for the whole fleet, the count of all voyages, or the sum of the money you are making per voyage.

1. To use a field or column in a function, do one of the following:

   • Drag it to the Aggregate Functions pane.

   • Right-click it in the Tables pane and click Aggregate.
     
     

     Open

     

2. The type of aggregation possible depends on the data type of the field. In the Aggregate Functions pane, click the down arrow on the field name and select one of the following:

   • Avg: The average of all non-null values in the column

   • Count: The count of all non-null values in the column
     
     

   • Max: The maximum of all non-null values in the column

   • Min: The minimum of all non-null values in the column

   • Sum: The sum of all values in the column