Yield Week-On-Week: Difference between revisions
| (3 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
!Description | !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). | |||
|} | |} | ||
| Line 19: | Line 40: | ||
!Transformations | !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. | |||
|} | |} | ||
| Line 30: | Line 67: | ||
!Description | !Description | ||
|- | |- | ||
| | |1. T'''otalYield by Week Number And HOS Entity''' | ||
| | |TotalYield = | ||
| | <pre>IF ( | ||
AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ), | |||
[Total Revenue Site] / [Chargeable Weight] | |||
)</pre> | |||
|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 =<pre>IF ( | |||
AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ), | |||
[Total Revenue Site] / [Chargeable Weight] | |||
)</pre> | |||
|This is a table that displays Yield across different entities calculated by diving revenue by chargeable weight. | |||
|} | |} | ||
Latest revision as of 14:00, 1 October 2025
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), |
|
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. |