Logistics dashboards: metrics, layout, and checks

Logistics dashboards compare delivery performance, freight spending, and shipment exceptions by carrier, lane, and customer. Build the page from a reconciled shipment export, give every measure a clear denominator, and put the records requiring action beneath the totals. The layout should help the transportation team investigate a missed promise or a cost difference without guessing what the numbers include.

1. Choose the review cohort and source records

Start with the decision: which carrier, lane, or customer needs attention in the next transportation review? An operational dashboard can span several processes; this view is specifically about shipment service and freight cost.

For the worked example, use shipments due on October 8, 2026, reviewed as of October 12, 2026. Include shipments that remained undelivered past their deadline, had there been any. Exclude canceled shipments under a documented rule, and keep future-due shipments in a separate open-work view.

Export shipment ID, carrier, origin, destination, customer, agreed due date, actual delivery date, and status. Derive the lane from a consistent origin-destination definition. Bring invoice lines or approved freight accruals separately, then consolidate their components to one total per shipment before matching them to the shipment list.

Specify the cost basis. Here freight includes each shipment's base transport charge, fuel, and accessorial charges, all in USD. Every example shipment is delivered by the review cutoff and has a complete accrued cost. These are illustrative business records, not a carrier benchmark.

2. Agree on the delivery rule before calculating

This dashboard tests actual delivery date against the agreed due date, allowing delivery on or before that date. It measures timing only. If contracts require a delivery window or specific appointment time, use those boundaries instead and retain the original promise.

Use the existing explanation of OTIF, fill rate, and on-time delivery when selecting the customer-facing service measure. A shipment arriving on time does not establish that every ordered item arrived in full.

Enter the following export in worksheet columns A:G, with headers in row 1. Dates are US dates; currency values are plain USD amounts.

Add an on-time flag in H2 and fill down:

=IF(E2="","Missing promise",IF(F2="",0,--(F2<=E2)))

This formula assumes the file is already restricted to eligible shipments due by the cutoff. A missing delivery becomes zero because the shipment is already due. A missing promise requires correction rather than an invented deadline.

3. Build the top measures and grouped comparisons

The first row of the dashboard should show its cutoff and cohort, followed by shipment count, service, freight total, and freight per shipment. Use these Excel formulas on the six example rows:

=COUNTA(A2:A7)
=IF(COUNT(H2:H7)<>COUNTA(A2:A7),"Review flags",SUM(H2:H7)/COUNT(H2:H7))
=SUM(G2:G7)
=SUM(G2:G7)/COUNTA(A2:A7)

The count formula assumes the distinct-ID check has passed. It cannot itself detect duplicate shipment rows.

Below those totals, create a carrier summary. Put Alpha and Beta in K2:K3. Calculate shipments, on-time shipments, and freight in L2:N2, then fill down:

=COUNTIFS($B$2:$B$7,K2)
=COUNTIFS($B$2:$B$7,K2,$H$2:$H$7,1)
=SUMIFS($G$2:$G$7,$B$2:$B$7,K2)

Microsoft documents COUNTIFS as counting rows where all specified criteria are met. Its SUMIFS documentation explains summing amounts that meet the criteria. Covirage is not affiliated with Microsoft.

Use =M2/L2 for carrier service and =N2/L2 for cost per shipment.

Round rates to one decimal place and money to two decimals after calculating. Reconcile 3 + 3 = 6 shipments, 2 + 2 = 4 on-time shipments, and $700 + $680 = $1,380. Recalculate the company cost from total freight and total shipments rather than averaging displayed costs.

4. Lay out comparisons above an actionable exception list

Place carrier and lane comparisons in the middle of the page, with shipment counts beside rates. For lane analysis, replace the carrier criteria range B with lane column C in the grouped formulas. For customer analysis, use D. Keep the date and cost basis identical across those views.

Do not rank carriers on average cost alone. Different lanes, shipment sizes, and service commitments can explain a difference. Use the comparison to choose records for investigation, then inspect the relevant attributes before proposing a carrier change.

At the bottom, show the late shipments with their source IDs and assigned review owners:

The two late shipments carry $240 + $220 = $460 in freight. That is associated shipment spending, not proven incremental cost caused by lateness. Record the confirmed cause and next action separately. A client dashboard may present agreed customer results, while this operational view retains the investigation detail.

Where logistics dashboards go wrong

• Invoice lines multiply shipments. Consolidate charges before counting or calculating service.
• Only delivered shipments remain. Keep overdue undelivered work in the due-cohort denominator.
• Promise dates are overwritten. Preserve the date against which service was agreed and log revisions.
• Rates hide small or different cohorts. Display counts and compare like lanes and service commitments.
• Missing charges become zero cost. Mark incomplete freight and reconcile approved accruals before comparing carriers.

Build the review from your own shipment file in Covirage

Bring your shipment export and matching freight amounts to Covirage; it maps the columns, its tools compute and check the measures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See the shipping and logistics industry page for the supporting business context.