Directions report

Updated 4 weeks ago by Katarzyna

Who can use this function?

The function is available for CargoON and Trans for Forwarders users who have purchased a supplementary product: BI reports.

Reports are visible to selected users indicated by the company requesting access.

Learn more about BI reports.

The Directions report will allow you to check in which directions your costs generated using the Trans.eu Platform are increasing and in which they are decreasing.

With the report you can:

  • see how your costs are distributed across:
    • particular countries in which you carry out transports,
    • employees who manage transport directions,
    • amount of freights,
    • estimated kilometers,
    • particular months.
  • monitor cost increases and decreases, analyze where and why they occur.
  • control the number of transactions and related costs.
  • check what share your employees have in the costs related to managing particular directions.

The data scope of the Directions Report is based on the data obtained from the Freights module and includes all freights for which a formal transaction has been concluded.

The cost calculation is based on the date of unloading the freight.

Currency rates are converted according to the day of unloading the freight.

The Directions report can be found in the BI reports module by opening the tab visible in the top menu.

After clicking on the tab, you will see a report consisting of 5 main sections:

  1. KPI's tiles - showing the values of the entire company
  2. Directions chart - showing costs for the top 5 directions.
  3. Exact directions table - showing costs in exact directions.
  4. Maps with places of loading and unloading.
  5. Employees - a table showing the share of employees in the costs in a given direction.

KPI's tiles

The upper bar of the report shows the sum of values for the time period specified in the filters. It illustrates the trend of individual values comparing them to the previous period.

Learn more about each tile

Accepted freights - the total number of all formally accepted freights - those where the transaction was concluded.
Total transportation costs - costs of all accepted freights.
Costs per freight - costs calculated per freight.
Total km - the number of kilometers traveled
Costs per km - average cost per kilometer.
Number of negotiations - number of negotiations held.
Number of responses - number of responses to offer inquiries.

Directions Chart

In this part of the report, you will find detailed data presented using indicators and columns:

  • Name of direction - 5 most popular directions are displayed by default.
If you want to see values for more directions, use the Show top N slider.
With filters discussed below, you can indicate the directions you are interested in.

  • The total number of accepted freights in a given direction - the sum provided with the comparative indicator. The current period is compared to the previous one, which can be specified using filters.
    The blue and red arrows show whether the trend for the month is up or down.
When you hover over the arrow, you will see to which period the given value is compared. You can change the date range using filters

  • The total sum of costs in a given direction - it is the cost per freight (quotient of the accepted freights and the total cost in the direction).
  • The total sum of kilometers on routes accepted for a given direction - the sum is provided together with the comparative indicator. It is a general calculation.
  • Average cost per kilometer - total costs have been converted to the total number of kilometers. These are general estimates.

You can filter this part of the report by:

  • loading place - you will get data showing the costs at the place of loading,
  • unloading place - you will get data showing the costs incurred at the place of unloading,
  • direction.
Filtering affects both the Directions and Exact directions view.

Remember that the route may have intermediate places between the first and last place of loading. They are included in the costs, although we do not present them in the chart.

Exact Directions Chart

This part of the report is a deeper analysis of the data from the Directions section. You can analyze the number of negotiations and responses, number of accepted freights, their costs and kilometers, based on specific directions, including exact addresses.

You can filter this part of the report by:

  • loading place - you will get data showing the costs at the place of loading,
  • unloading place - you will get data showing the costs incurred at the place of unloading,
  • direction.

Filtering affects both the Directions and Exact directions view.

Loading/Unloading Countries Maps

On the maps, you can see the countries where freight operations took place.

Loading Countries - the map shows places of  loading. Unloading Countries - places of unloading.

The colors on the map show how many operations have been carried out in a given country - the darker the color, the more freights.

The values shown on the maps depend on the selected parameter - for example, you can specify whether you want to check which countries generate the highest costs for you or where the highest rates apply.

You can filter this part of the report by:

  • number of accepted freights,
  • transport cost,
  • transport cost broken down by freight,
  • transport cost broken down by kilometers traveled,
  • responses to published offers,
  • negotiations held.

Employees

The chart presents the share of employees in the costs in a given direction.

See on which directions employees generate the highest and lowest costs

Filtering

Click the filter symbol in the right column to open the Directions report filter settings.

Set filters according to the type of information you are interested in.

In the filter settings you can choose:

  • range of displayed data (Unloading date)
  • currency of the transaction (Currency)
  • Loading country
  • Unloading country
  • Employee

Freight table

You can turn on the table view, where you will see all the freights included in the report. To do this, turn on the slider next to Details.

The i icon shows the range of data.


How Did We Do?

UP!
Powered by HelpDocs (opens in a new tab)