Welcome to the Veson Nautical Knowledge Base. In the Help Center, you can view the same articles and contact support as needed.

IMOS - Adding Aggregate Functions

Error rendering macro 'excerpt-include' : No link could be created for 'Veson IMOS Platform Documentation'.

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, on a joined table in the Report Designer panel, click  and then click Aggregate.
  2. The type of aggregation possible depends on the data type of the field. In the Report Designer panel, click  to the right of 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

Still need help? Visit the Veson Nautical Help Center.

Copyright © 2017-2024 Veson Nautical LLC All Rights Reserved - Privacy Notice | End User Terms of Use