Yield Week-On-Week

Summary

This Yield Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays Total Yield by week number across different entities.

Filters

Filter	Description
Database	Select the reporting database.
Site	Choose the location or branch for the report.
Carrier	Filter by transport provider.
Service	Narrow results by type of service offered.
Customer	View data for a specific customer.
Commodity Type	Filter by category of goods.
Product Type	Select specific product groups.
Date	Define the reporting period (weekly, monthly, or custom range).

Data Transformation Applied

Query	Transformations
let     Source = MySQL.Database(         "qms-reporting.cluster-ro-cbuxcavwaolv.eu-west-2.rds.amazonaws.com",         "db",         [             ReturnSingleDatabase = true,             CommandTimeout = #duration(0, 10, 0, 0),	Formatting – Data is arranged into a consistent structure used across all report pages. Merging – Related tables (e.g., customers, carriers, services) are combined so the report shows complete information in one place. Combining – Combined four tables (Groupair, AirCross, HAE, And ACS) Cleaning – Any extra technical fields are removed, and values are standardized for easy reading.

Calculations

Columns	Calculation	Description
1. TotalYield by Week Number And HOS Entity	TotalYield = IF (     AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ),     [Total Revenue Site] / [Chargeable Weight] )	Total Yield Site calculates yield for a site by dividing total revenue by chargeable weight (only when both values are greater than zero).
2. TotalYield by Entity	TotalYield = IF (     AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ),     [Total Revenue Site] / [Chargeable Weight] )	This is a table that displays Yield across different entities calculated by diving revenue by chargeable weight.