Trend Analysis

 

In this article

1. Overview
2. Export to Excel
3. Filters
    3.1. By Category
    3.2. By Week or Month
    3.3. By Time Period
    3.4. Sorting
4. Charts

Overview

This section, located in the Reporting section of the web app, provides chart reporting capabilities over a certain date range. We report the past 1 year as the default, but this date range can be modified to match your needs. Data is updated and reflected in this section on a daily so that you can explore trends by week and month.

The dates shown on the Weekly Report are based on the Work Week Start Day set within Settings > Preferences. Monday is the value by default.

Export to Excel

The entire report can be exported to Excel by clicking the option at the top right of the page. Included in this file are two additional metrics:

Empty/Total Miles Percentage of empty miles per total miles
Loaded/Total Miles Percentage of loaded miles per total miles

Filters

By Category

There are four main categories that you can filter against: Driver, Customer, Tractor, and Trailer. Use the filters along the top to select the category you would like to analyze.

undefined-Apr-29-2022-01-16-03-07-PM

By Week or Month

Use the toggle at the top right to view your data trending week-over-week or month-over-month.

undefined-Apr-29-2022-01-16-03-25-PM

By Time Period

Use the Period filter to view data aggregated by one of the options below. Click the arrow to the right of this filter to sort your data in ascending or descending order.

  • Last 1 Year
  • Last 2 Years
  • Whole Period

undefined-Apr-29-2022-01-16-02-72-PM

Sorting

Clicking the Sort arrow to the right of the Period filter sorts all charts in ascending or descending order.

undefined-Apr-29-2022-01-16-02-00-PM

Charts

The list below includes the current charts that are available to help you analyze your data within Axele. You can find an example of each chart below the list of charts.

  • Mileage KPIs
    • Loaded miles
    • Empty miles
  • Number of Loads
  • Revenue
    • Gross revenue
    • Driver payment
  • Average Revenue per Mile
    • Average $ per loaded mile
    • Average $ per total mile

Each of these examples are weekly reports. You can switch to view a monthly view by clicking Monthly at the top right of this page within Axele.

undefined-Apr-29-2022-01-16-02-32-PM

undefined-Apr-29-2022-01-16-02-90-PM

undefined-Apr-29-2022-01-16-02-13-PM-1

undefined-Apr-29-2022-01-16-02-48-PM-1