IMOS On-Prem - Aggregate Functions

View IMOS Documentation in the Help Center.

In the Aggregate Functions section of the Report Editor, you can select columns and average, count, sum, or perform another function on them. 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.

To set up aggregate functions for the report:

1. To add a new aggregate function, click .
2. Select a numeric Column to aggregate and a Function. The following functions are available:
   • Average: The average of all non-null values in the column
   • Count: The count of all non-null values in the column
   • Count Distinct: The count of all distinct non-null values in the column
   • Custom Average: The value of the sum of the selected Numerator column's non-null values divided by the sum of selected Denominator column's non-null values
   • Maximum: The maximum of all non-null values in the column
   • Minimum: The minimum of all non-null values in the column
   • Standard Deviation: The standard deviation (that is, the measure of the variability or dispersion of values) of all non-null values in the column
   • Sum: The sum of all values in the column
   • Variance: The variance (that is, the measure of the values' spread; the square root of the variance is the Standard Deviation) of all non-null values in the column