Table of Contents


  1. Introduction

  2. Report Sections
    1. Print, Export, Settings and Report Buttons
    2. Query
    3. Filters
    4. Aggregates
    5. Data Table

  3. Data Table
    1. Headings and Subheadings
    2. Sorting
    3. Column Management
    4. Breadcrumb View

  4. Examples - Sample Reports



    

With the latest update to our Navistream web portal, we've introduced a new report structure that allows for some very powerful, advanced reporting.


You can access this report by clicking on the "Reports" section at the top of the web page and selecting either the Trip Summary or Cycle Summary reports.


Below is brief guide of how this new report structure works and the features within:



Report Sections


  1. Print, Export, Settings and Report Buttons


    Found in the top right of the report, these allow the following:
    1. Print - Print the report you're currently viewing.

    2. Export - Export your current report into an excel spreadsheet.

    3. Settings - Change your personal settings for report viewing. These include display and export formats and has options for time, distance and speed, duration, mileage and volume.

    4. Report - Similar to a "file" menu, allows you to start a new report, save your current report, open a saved report among other similar features.





  1. Query

    • The Query area is the identifier of what data is showing up in your report.

    • When opened, the default query is loaded (whatever that may be).

    • Clicking in the query area allows you to add to or change the existing query. Data will
      update automatically.

    • Reset your query back to the default by clicking the options button (3 dots) on the right, then clicking "Reset panel to default".




  1. Filters

    • This area shows you any filters on your current query/report.

    • Click into this area to add or modify a filter. Data will update automatically when a new filter is added.

    • Clicking any underlined value in the data table will automatically add that value to your filters.

    • Reset your filters back to the default by clicking the options button (3 dots) on the right, then clicking "Revert Panel to Default".

    • You can remove outliers and statistical anomalies from your report by using the options provided in the "Additional Filters". There are some other options in here as well that may be useful in building specialized trip reports for your needs.




  1. Aggregates

    • Shows an aggregation of your currently active query and filters.

    • Clicking this line provides more detailed information and aggregation.


  2. Data Table

    • The line at the top (with the magnifying glass) allows you to quickly search your full data table (below) for values.

    • The full data table is the "meat" of your report.

    • Data is shown with a number of headings and columns which can be customized.

    • More information about the data table is in the section below.



Data Table



  1. Headings and Subheadings

    • Each report has a series of headings and subheadings that organize that data you're viewing.

    • The first row are generally viewed as sections for the headings and data below them. i.e. Trip Resources and Route.

    • Below each section heading are further subheadings for the data you're viewing such as Start Time, Vehicle and Trailer(s).


  2.  Sorting

    • Click any subheading to sort that column.

    • Click again to change the direction the data is sorted (ascending or descending).


  3. Column Management

    • Each heading or column of data has an options button.

    • Put your mouse on the heading, then click the details/options button (3 horizontal lines) to access the column management features.

    • Features include:
      1. Pinning - Pin a column to the left or right side of the report so it's always visible no matter how far you scroll left or right.

      2. Grouping - Changes the way your report is presented by first grouping your data by values contained in the columns you chose to group by. A new group subheading is added to the left side of the report that includes the grouping data. To remove the grouping, press the 'x' button beside "Grouping Active" that will appear to the right of the Data Table Search heading.

      3. Advanced Filtering - After clicking the options button, more buttons appear right beside it. The second button allows you to create an advanced filter in that column using expressions such as "contains", "equal", etc. This filter is only on that column and does not apply to the whole data table.

      4. Add/Remove columns - Beside the filter button is the "columns" button. Clicking this will show a list of all columns in the data table. Unchecking a box will remove that column from your report so you can hide unnecessary data. To add them back, press the same button and check the appropriate box once more.

  4. Breadcrumb View

    • One column on the report looks like a Google Maps "Pin".

    • Clicking on this icon in the column will take you to a special map showing the route the driver took on this trip.

    • A legend is shown at the bottom of the map to help you read it.

    • You can zoom the map with your keyboard and mouse. Hold down the CTRL key on your keyboard and scroll using your mouse or touch pad to zoom in and out. The + and - buttons in the corner will also help you zoom in and out.

    • Google street view is available on this map as well. Drag the little orange person onto any highlighted blue area to access.



Examples - Sample Reports



  1. All trips this week ending at a certain location:

    1. Click into the Query field at the top and change the Date Range field to "Last 7 Days".

    2. Click into Filters and change the Unload Locations field to the area you're interested in.

    3. Hide any columns you're not interested in by pressing on the options field of any column, pressing the columns icon, and un-checking the fields you don't want to see.

    4. Apply an appropriate sort to your data by clicking on the heading of that column.

    5. Export or print your report by using the buttons at the top right of the screen.


  2. Be emailed a report of all trips for the day the following morning:

    1. Click into the Query field at the top and change the Date Range field to "Yesterday".

    2. Hide any columns you're not interested in by pressing on the options field of any column, pressing the columns icon, and un-checking the fields you don't want to see.

    3. Apply an appropriate sort to your data by clicking on the heading of that column.

    4. Click on "Report" in the top right of the screen and select "Schedule Report".

    5. Enter the email address you'd like to receive the report at in the "Deliver to" field.

    6. Day is already selected and is the only option in the "Every" field. More options are coming soon!

    7. Select a time in the morning you'd like to receive the report. Put this time in the "At" field.

    8. If you have a certain time you'd like to stop receiving this report, enter it into the "Until" field.

    9. Click "Save and Schedule" when finished.