| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
This is a Key Topic, with high value for all users.
...
Note: To create, edit, and copy Report Editor reports, the Report Editor (Legacy) - Create/Edit Reports Module Right must be selected for you in Security.
In this example, we will create a report that shows a summary of key information for each voyage. This example report shows all voyages with high-level voyage and cargo details. Additionally, it shows an aggregate of Total Voyage Days, Sea Days and Port Days, along with total Cargo Quantity. The report can be further customized to filter the data to bring attention to specific voyages where a certain condition exists. This conditional formatting can be done with custom expressions.
Creating the Report
To create this report, complete each section of the Report Editor:
...
- Sort this report by Vessel Name.
Aggregate Functions.
- Add the following aggregates for a quick summary of results:
- Voyage No || Count Distinct: Counts the number of distinct voyage records for each vessel group.
- Voyage (Actual) Total Days || Sum: Sums up the total number of voyage days.
- Voyage (Actual) Port Days || Sum: Sums up the total number of port days.
- Voyage (Actual) Sea Days || Sum: Sums up the total number of sea days.
- Voyage (Actual) CP Quantity || Sum: Sums up the total number of contracted cargo quantity.
...