Network Cost Analysis and Performance Reports

You can view cost analysis and performance reports for the network, partners, and carriers. Afterward, you can export the report to an Excel spreadsheet or view in a pivot table with options for views as a grid, pie chart, bar chart, line chart, or scatter chart. The following procedure shows how to view a network cost analysis report. This procedure is similar to those for the cost analysis reports for partners and carriers as well as for performance reports for a network, partners, and carriers.

Complete the following steps to view network cost analysis reports:

  1. L og in to the ONE system.

  2. Select Menu/Favs > Reports > Analyze > Network Cost Analysis.
    In the NEO UI, users can click on the Menus/Favs icon on the left sidebar and type in the name of the screen in the menu search bar. For more information, see "Using the Menu Search Bar."

    The Network Cost Analysis screen appears.

    images/download/attachments/131830043/2021-04-15_10-42-55-version-1-modificationdate-1629212871000-api-v2.png



  3. Click the Filters (edit) link to apply search criteria to reduce the number of entries shown.
    The Filters menu displays.

    images/download/attachments/131830043/2021-04-15_10-43-56-version-1-modificationdate-1629212871000-api-v2.png

  4. To add more search filters, click the Add Filter link, and then click one or more filter options from the Add Filter list.

  5. Fill out the filters as desired, and click the Search link.
    The search results display.

  6. Click the View Pivot button to view the report in a pivot table.

    images/download/attachments/131830043/2021-04-15_10-46-11-version-1-modificationdate-1629212871000-api-v2.png

    The Analytics Pivot screen appears.

    images/download/attachments/131830043/2021-04-15_10-46-51-version-1-modificationdate-1629212871000-api-v2.png



  7. Drag and drop options from the Select Dimensions list onto the Report Filter, Rows, Columns, and Values boxes to c reate the layout of the pivot table.

    images/download/attachments/131830043/worddav37b273fcff30e1fcbe5ff8ced98b774a-version-1-modificationdate-1629212871000-api-v2.png

  8. To select another operation on the value, click the option button to open the operation list, and then click an option.

    images/download/attachments/131830043/worddav015af087f658b3f474988f1798327a77-version-1-modificationdate-1629212871000-api-v2.png

  9. After all dimensions and values have been selected, click OK. The pivot table appears in the default grid view.

    images/download/attachments/131830043/worddav2da00197a39766f6f79ad9207b104d33-version-1-modificationdate-1629212872000-api-v2.png

  10. To change the Report Filter (Month in the following figure), click the option arrow to open the filter list.

  11. As required, type characters into the Filter box to match equipment names, or scroll the list until the desired equipment is visible. Click the equipment name to select it, and then click OK.

    images/download/attachments/131830043/worddav3f71f51c90bccbeabd9bd442fbf6aa93-version-1-modificationdate-1629212872000-api-v2.png

  12. Similarly, click the option arrow on the row selection to view filter and sort options.

    images/download/attachments/131830043/worddav99e566123e68f3d55ac100c5cc93f999-version-1-modificationdate-1629212872000-api-v2.png

  13. To view the pivot table in a graphical chart, click the Charts button, and then click a chart option from the list.

    images/download/attachments/131830043/worddav5222d29a24c5bc655dcec086c039da40-version-1-modificationdate-1629212871000-api-v2.png

    The following figure shows the Bar Chart option.

    images/download/attachments/131830043/worddav56cd1cceecebd6cbcffee014d9f3470b-version-1-modificationdate-1629212871000-api-v2.png

    The following figure shows the Pie Chart option.

    images/download/attachments/131830043/worddava9e1b452ae34b649409293329cb3511f-version-1-modificationdate-1629212871000-api-v2.png

  14. To select another value option, click the option arrow, and then click an option from the list.

    images/download/attachments/131830043/worddav605fd2ef443d0063b4ffa9e2cf9dd381-version-1-modificationdate-1629212871000-api-v2.png

  15. To return to the grid view, click the Grid View button.

  16. To export the table to a file format, click the Export button.

    images/download/attachments/131830043/worddav81e61190d68d0a44ab04563cebca54e9-version-1-modificationdate-1629212871000-api-v2.png

  17. To view the pivot full screen, click the Full Screen button.

  18. To return to normal screen, press ESC.

  19. While in Grid View, click the Zoom button to select a zoom level from 70% to 130% to resize the table grid.

    images/download/attachments/131830043/worddavf7cf5c21bb536aa90cf44bbb4d47dffa-version-1-modificationdate-1629212871000-api-v2.png

Adding Price Column to Network Analysis Report

Users can view Standard Network Analysis reports and gain insight into the entire network including clients, shippers, and partners. The new Price column is added to the standard network reports for calculating revenue per lane and cost prices. Uses can add or hide the Price column as needed.

Complete the following steps to view the network analysis report:

  1. L og in to the ONE system.

  2. Select Menu/Favs > Reports > Analyze > Network Cost Analysis.
    In the NEO UI, users can click on the Menus/Favs icon on the left sidebar and type in the name of the screen in the menu search bar. For more information, see "Using the Menu Search Bar."

    The Network Analysis report appears.

  3. Click any column header link and select Columns and click the Price checkbox.

    images/download/attachments/131830043/nar01-version-1-modificationdate-1629212871000-api-v2.png

    The Price column appears in the report.

  4. Click View Pivot to view the report in the pivot format.

  5. Click the Export to CSV button to export the report to a CSV file.