This is a tutorial video to summarize your previously submitted trip reports in eTRIPs
In this example, we will summarize the reported quantity landed in year 2025 by dealer sold to and species. This process can be used for other date periods or groups.
From the SAFIS main menu select SAFIS Electronic Trip Reports eTRIPS.
You will arrive at the eTRIPs home. Choose the Data reports drop down menu, then select trip interactive data report. It may take a few moments for the next page to load.
Once the next page loads, we will filter the data by date. Select the actions drop down button, then choose filter.
Select the column drop down button, then choose trip start date from the list.
Select the operator drop down button, then choose between from the list.
An expression will appear with two date fields separate by the word and In the first date field, enter the first date of the year by selecting the calendar icon.
A calendar will appear. Select the month drop down list and choose January. Now select the year drop down button and choose 2025. Select the first day of January from the calendar.
In the second date field, enter the last date of the year by selecting the calendar icon. A calendar will appear. Select the month drop down button and choose December. Now select the Year drop down button, then choose 2025. Select the 31st day of December from the calendar. Now select Apply.
There may be a delay as the filter is applied to the data. Now select the actions drop down button, then choose group by. The group by screen will appear. This provides options for summarizing trip report data.
In this example, we will summarize reported quantity by species and dealer. Now use the select group by column drop down button. Then choose dealer name. To add another group by column, select the add group by column button. Now use the new select group by column button to choose species from the drop-down list.
Now it is time to set the functions that summarize the data. use the Select function drop down button, then choose some from the list. Next, use the select column button. Then choose reported quantity.
Now select the format mask drop down arrow to choose the format for sum of reported quantity from the examples provided. For instance, in this example we chose 5234.10 which means the data will return in decimal hundredths. An odd code will appear in the box. It is OK to ignore. To add a grand total to your table, choose the sum toggle button.
Finally, select apply to see a summary of the data. A table showing reported quantity sold of each species by dealer appears. In this example, the dealer name is blank for species not sold to a dealer.
You can repeat this process with groupings that fit your desired table result. This is the end of the tutorial.