Yield - Group Overview

Summary

This page is part of the Weight and Revenue GSA report. It provides a summary of weekly and monthly yield performance, group targets, and corresponding figures for revenue and weights.

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. Total Yield And Group Target By Year	GroupTarget = 1.73 TotalYield = IF ( AND ( [Chargeable Weight] > 0, [Total Revenue In euro] > 0 ), [Total Revenue In euro] / [Chargeable Weight] )	Group Target – Estimated average yield target across all sites. Total Yield – Calculated by dividing revenue by chargeable weight.
2. Monthly Figures	Total Revenue = SUM('Combined Quatations Tables2'[Revenue In EURO])	This is a matrix table that displays revenue (EUR) by weight in kilos and Tonnes, along with their monthly figures.
3.Weekly Figures	Total Revenue = SUM('Combined Quatations Tables2'[Revenue In EURO])	This is a matrix table that displays revenue (EUR) by weight in kilos and tonnes, along with their weekly figures.
4. Total Revenue and Chargeable Weight By Date	Total Revenue = SUM('Combined Quatations Tables2'[Revenue In EURO]) CHW (KG) = SUMX (     'Combined Quatations Tables2',     IF (         'Combined Quatations Tables2'[weight_unit] = "lb",         'Combined Quatations Tables2'[chargeable_weight] * 0.45359237,         'Combined Quatations Tables2'[chargeable_weight]   -- already in KG     ) )	This is a line chart that shows chargeable weight and revenue by date, with revenue calculated by summing up values from the combined tables.
5. Group Target and Target Yield by Month	GroupTarget = 1.73 Target Yield = SWITCH(     TRUE(),         SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "hae", 0.87,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "alb", 2.92,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "hai", 2.78,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "us", 2.03,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "nbo", 0.88,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "dxb", 0.68,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "scl", 1.76,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "HAE" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "sao", 2.34,     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "AIRCROSS" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "AirCross", 1.00,  -- placeholder     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "ACS" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "Ireland", 1.00,   -- placeholder     SELECTEDVALUE('Combined Quatations Tables2'[Database]) = "GROUPAIR" &&     SELECTEDVALUE('Combined Quatations Tables2'[Site]) = "GPA", 1.00,   -- placeholder     BLANK() )	The Group Target and Target Yield by Month are displayed in a line chart. These values are based on preset targets for various sites and show monthly benchmarks for comparison against actual performance.
6. Total Revenue and Chargeable Weight by Month	Total Revenue In euro = SUM('Combined Quatations Tables2'[Revenue In EURO]) CHW (KG) = SUMX (     'Combined Quatations Tables2',     IF (         'Combined Quatations Tables2'[weight_unit] = "lb",         'Combined Quatations Tables2'[chargeable_weight] * 0.45359237,         'Combined Quatations Tables2'[chargeable_weight]   -- already in KG     ) )	This is a line chart that displays revenue (EUR) and Chargeable Weights by their respective months.