PBI Reporting Wiki - User contributions [en-gb]

Datacair EY Performance Report - Dashboard

2026-02-20T08:53:09Z

Stanley.songok: /* Filters */

== Summary ==

This report provides a weekly overview of operational performance by tracking AWBs, execution status, pending workload, customer issues (CAMS), and closure rates. Using simple metrics, filters by station and date, and clear percentage changes, it helps teams quickly identify performance trends, growth areas, and operational risks to support timely and data-driven decisions.

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|Station
|Filters the report to show data for a specific operational station
|-
|Status
|Filters records based on issue resolution status:
'''Resolved''' (issues that have been closed) and '''Unresolved''' (issues still open and pending action).
|-
|Date
|Filters the data to a selected date range for time-based analysis
|-
|Weekly
|Filters data based on selected week number of that year
|-
|Year
|Filters data based on selected year
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|1. EY Performance Report
|Cleaned the dataset by correcting column data types (dates, numbers, text) to ensure accurate calculations and filtering.
|-
|2.Pending AWBs
|Standardized data types and prepared the table for relationship mapping with Stations.
|-
|3.Reopened AWBs
|Corrected data types and validated station identifiers for consistent joins.
|-
|4.Stations
|Used as a master reference table to provide station details for all operational datasets.
|-
|5.Calendar
|Created and linked to date fields to support time-based analysis (weekly and monthly trends).
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. Total AWBs
|Sum of all AWBs
|Total number of Air Waybills created in the selected period
|-
|2. Total Executed AWBs
|Sum of executed AWBs
|Number of AWBs that were successfully processed or completed
|-
|3.Total Pending AWBs
|Sum of pending AWBs
|Number of AWBs still awaiting execution
|-
|4.Total CAMS Raised
|Sum of CAMS cases
|Total number of customer or operational issues raised
|-
|5.Total CR
|Average of Completion Rate
|Overall closure rate showing operational efficiency
|-
|6.Total CR (EY)
|Average of Completion Rate EY Fault Removed
|Closure rate based on EY-specific business rules
|}

Datacair EY Performance Report - Airway Bills

2026-02-04T08:32:31Z

Stanley.songok: /* Calculations */

== Summary ==

This table provides an overview of Air Waybill (AWB) status by highlighting pending and reopened AWBs along with their raised and resolved dates. It helps teams track outstanding issues, monitor resolution timelines, and identify delays in the AWB handling process to support timely follow-up and operational efficiency.

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|Station
|Filters the report to show data for a specific cargo station or location. Helps compare performance across stations
|-
|Date
|Filters data by selected date range to analyze performance for a specific period (week, month, or custom range).
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|EY Performance Report
|Cleaned the dataset by correcting column data types (dates, numbers, text) to ensure accurate calculations and filtering.
|-
|Pending AWBs
|Standardized data types and prepared the table for relationship mapping with Stations.
|-
|Reopened AWBs
|Corrected data types and validated station identifiers for consistent joins.
|-
|Stations
|Used as a master reference table to provide station details for all operational datasets.
|-
|Calendar
|Created and linked to date fields to support time-based analysis (weekly and monthly trends).
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. Total AWBs
|Sum of all AWBs
|Total number of Air Waybills created in the selected period
|-
|2. Total Executed AWBs
|Sum of executed AWBs
|Number of AWBs that were successfully processed or completed
|-
|3.Total Pending AWBs
|Sum of pending AWBs
|Number of AWBs still awaiting execution
|-
|4.Total CAMS Raised
|Sum of CAMS cases
|Total number of customer or operational issues raised
|-
|5.Total CR
|Average of Completion Rate
|Overall closure rate showing operational efficiency
|-
|6.Total CR (EY)
|Average of Completion Rate EY Fault Removed
|Closure rate based on EY-specific business rules
|}

Datacair EY Performance Report - Airway Bills

2026-02-04T08:31:49Z

Stanley.songok: /* Data Transformation Applied */

Datacair EY Performance Report - Airway Bills

2026-02-04T08:30:59Z

Stanley.songok: /* Filters */

Datacair EY Performance Report - Airway Bills

2026-02-04T08:30:11Z

Stanley.songok: /* Summary */

Datacair EY Performance Report - Detail

2026-02-04T08:18:19Z

Stanley.songok: /* Calculations */

== Summary ==

This table presents a weekly snapshot of cargo operations performance, displaying Current Week, Previous Week, and Week-over-Week (WoW) changes for key metrics including AWBs, Executed AWBs, Pending AWBs, CAMS Raised, Completion Rate (CR), and Completion Rate (CR-EY).

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|Station
|Filters the report to show data for a specific cargo station or location. Helps compare performance across stations
|-
|Date
|Filters data by selected date range to analyze performance for a specific period (week, month, or custom range).
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|EY Performance Report
|Cleaned the dataset by correcting column data types (dates, numbers, text) to ensure accurate calculations and filtering.
|-
|Pending AWBs
|Standardized data types and prepared the table for relationship mapping with Stations.
|-
|Reopened AWBs
|Corrected data types and validated station identifiers for consistent joins.
|-
|Stations
|Used as a master reference table to provide station details for all operational datasets.
|-
|Calendar
|Created and linked to date fields to support time-based analysis (weekly and monthly trends).
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. Total AWBs
|Sum of all AWBs
|Total number of Air Waybills created in the selected period
|-
|2. Total Executed AWBs
|Sum of executed AWBs
|Number of AWBs that were successfully processed or completed
|-
|3.Total Pending AWBs
|Sum of pending AWBs
|Number of AWBs still awaiting execution
|-
|4.Total CAMS Raised
|Sum of CAMS cases
|Total number of customer or operational issues raised
|-
|5.Total CR
|Average of Completion Rate
|Overall closure rate showing operational efficiency
|-
|6.Total CR (EY)
|Average of Completion Rate EY Fault Removed
|Closure rate based on EY-specific business rules
|}

Datacair EY Performance Report - Detail

2026-02-04T08:14:35Z

Stanley.songok: /* Data Transformation Applied */

Datacair EY Performance Report - Detail

2026-02-04T08:10:35Z

Stanley.songok: /* Summary */

Job Finder

2025-10-02T13:03:10Z

Stanley.songok: /* Calculations */

== Summary ==
The Job Finder page is part of the Yield, Weight, and Revenue GSA report. It summarizes monthly and weekly figures for revenue and carriers.

== Filters ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. '''Monthly Figures'''
|Total Revenue In euro = <pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
|'''Monthly Figures Table''' – Displays Total Yield, Chargeable Weight (in tonnes and kilograms), and related values summarized by month across different years. It helps compare performance trends year over year.
|-
|2.'''Weekly Figures'''
|Total Revenue In euro =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
|shows the same measures (Total Yield and Chargeable Weight in Tonnes and kilograms) but broken down by week numbers, allowing detailed week-on-week analysis.
|-
|3.'''Job Search'''
|Total Revenue In euro =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
|The Job Search table lists detailed job-level information, including Job ID, Gross Profit, Revenue in EUR, Carrier Name, Yield, Exchange Rate, and other related fields. It allows users to review and analyze individual job records for financial and operational insights.
|}

Job Finder

2025-10-02T12:57:51Z

Stanley.songok: /* Calculations */

Job Finder

2025-10-02T12:56:05Z

Stanley.songok: /* Calculations */

Job Finder

2025-10-02T12:55:33Z

Stanley.songok: /* Calculations */

== Summary ==
The Job Finder page is part of the Yield, Weight, and Revenue GSA report. It summarizes monthly and weekly figures for revenue and carriers.

== Filters ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. '''Monthly Figures'''
|Total Revenue In euro = SUM('Combined Quatations Tables2'[Revenue In EURO])
|'''Monthly Figures Table''' – Displays Total Yield, Chargeable Weight (in tonnes and kilograms), and related values summarized by month across different years. It helps compare performance trends year over year.
|}

Job Finder

2025-10-02T12:51:31Z

Stanley.songok: /* Data Transformation Applied */

Job Finder

2025-10-02T12:50:31Z

Stanley.songok: /* Filters */

Job Finder

2025-10-02T12:49:09Z

Stanley.songok: /* Summary */

== Summary ==
The Job Finder page is part of the Yield, Weight, and Revenue GSA report. It summarizes monthly and weekly figures for revenue and carriers.

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|
|
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}

Site Summary

2025-10-02T12:41:38Z

Stanley.songok: /* Calculations */

== Summary ==
The Site Summary page is part of the Yield, Weight, and Revenue report. It includes site currencies and displays data across various carriers.

== Filters ==
{| class="wikitable"
|+
!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).
|-
|'''Site Currency'''
|Select specific currency of the revenue.
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. '''Total Yield&Target Yield By Date'''
|TotalYield Site =
<pre>IF (

AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ),

[Total Revenue Site] / [Chargeable Weight]

)</pre>
Target Yield =
<pre>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()</pre>
|
* '''Total Yield Site''' – Calculates a site’s yield by dividing total revenue by chargeable weight (only when both are greater than zero).

* '''Target Yield''' – Uses preset target values for each site (based on the database and site name) to define the expected yield benchmark for comparison.
|-
|2. '''Total Revenue and Chargeable Weight By Date'''
|CHW (KG) =
<pre>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

)

)</pre>

Total Revenue Site = <pre>SUM('Combined Quatations Tables2'[Revenue2])</pre>
|
* '''CHW (KG)''' – Calculates the total chargeable weight in kilograms, converting from Lb where needed.

* '''Total Revenue Site''' – Sums up all revenue values for the selected site.
|-
|3. '''Total Revenue By Carrier'''
|Total Revenue Site =<pre>SUM('Combined Quatations Tables2'[Revenue2])</pre>
|Total Revenue by Carrier shows the sum of revenue grouped by each carrier, allowing comparison of carrier performance.
|-
|4.'''TotalYield and Target Yield By Month Year'''
|TotalYield Site =<pre>IF (

AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ),

[Total Revenue Site] / [Chargeable Weight]

)</pre>
|
* '''Total Yield by Month/Year''' – Shows the actual yield (revenue ÷ chargeable weight) summarized for each month and year.

* '''Target Yield by Month/Year''' – Displays the preset yield targets for each site, organized by month and year, for comparison against actual yield.
|-
|5. '''Total Revenue & Chargeable Weight By Month'''
|CHW (KG) =<pre>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

)

)</pre>

Total Revenue Site = <pre>SUM('Combined Quatations Tables2'[Revenue2])</pre>
|
* '''Total Revenue by Month/Year''' – Shows the total revenue summarized for each month and year.

* '''Chargeable Weight by Month/Year''' – Displays the total chargeable weight summarized for each month and year.
|-
|6. '''Total Yield By Carrier'''
|TotalYield Site =<pre>IF (

AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ),

[Total Revenue Site] / [Chargeable Weight]

)</pre>
|'''Total Yield by Carrier''' – Shows the actual yield (revenue ÷ chargeable weight) summarized for each carrier, allowing performance comparison across carriers.
|-
|7.'''Table Display'''
|Total Revenue Site =<pre>SUM('Combined Quatations Tables2'[Revenue2])</pre>
|This table displays weekly figures, including week numbers, yield, total revenue, and chargeable weight. It provides a detailed breakdown of performance metrics across weeks for easier comparison and trend analysis.
|}

Site Summary

2025-10-02T12:26:49Z

Stanley.songok: /* Calculations */

Site Summary

2025-10-02T11:58:59Z

Stanley.songok: /* Calculations */

Site Summary

2025-10-02T11:52:21Z

Stanley.songok: /* Calculations */

Site Summary

2025-10-02T11:47:20Z

Stanley.songok: /* Calculations */

Site Summary

2025-10-02T10:17:59Z

Stanley.songok: /* Calculations */

Site Summary

2025-10-02T10:11:45Z

Stanley.songok: /* Calculations */

Site Summary

2025-10-02T10:05:18Z

Stanley.songok: /* Data Transformation Applied */

Site Summary

2025-10-02T10:04:32Z

Stanley.songok: /* Summary */

Weight By Carrier

2025-10-02T08:37:47Z

Stanley.songok: /* Calculations */

== Summary ==
The Weight by Carrier page is part of the Yield, Weight, and Revenue GSA report. It shows chargeable weight by week, carrier, and entity.

== Filters ==
{| class="wikitable"
|+
!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).
|-
|'''Site Currency'''
|Select specific currency of the revenue.
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1'''.Chargeable Weight By Week Number'''
|CHW (KG) =
<pre>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

)

)</pre>
|CHW (KG) calculates the total chargeable weight in kilograms, converting from Lb when necessary and displayed in line chart.
|-
|2. '''Chargeable Weight By Carrier And Entity'''
|CHW (KG) =<pre>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

)

)</pre>
|CHW (KG) calculates the total chargeable weight in kilograms, converting from Lb when necessary and displayed in a table showing Entity and corresponding carriers.
|}

Weight By Carrier

2025-10-02T08:27:58Z

Stanley.songok: /* Calculations */

== Summary ==
The Weight by Carrier page is part of the Yield, Weight, and Revenue GSA report. It shows chargeable weight by week, carrier, and entity.

== Filters ==
{| class="wikitable"
|+
!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).
|-
|'''Site Currency'''
|Select specific currency of the revenue.
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1.Chargeable Weight By Week Number
|CHW (KG) =
<pre>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

)

)</pre>
|CHW (KG) calculates the total chargeable weight in kilograms, converting from Lb when necessary and displayed in line chart.
|}

Weight By Carrier

2025-10-02T08:27:12Z

Stanley.songok: /* Calculations */

== Summary ==
The Weight by Carrier page is part of the Yield, Weight, and Revenue GSA report. It shows chargeable weight by week, carrier, and entity.

== Filters ==
{| class="wikitable"
|+
!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).
|-
|'''Site Currency'''
|Select specific currency of the revenue.
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1.Chargeable Weight By Week Number
|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

)

)
|CHW (KG) calculates the total chargeable weight in kilograms, converting from Lb when necessary and displayed in line chart.
|}

Weight By Carrier

2025-10-02T08:21:38Z

Stanley.songok: /* Data Transformation Applied */

Weight By Carrier

2025-10-02T08:20:03Z

Stanley.songok: /* Summary */

Weight v Revenue Week-On-Week

2025-10-01T13:30:12Z

Stanley.songok: /* Calculations */

== Summary ==
The Weight vs Revenue Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays weekly revenue by entities.

== Filters ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1.'''Revenue and CHW(KG) by Week Number'''
|Total Revenue In euro = <pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
CHW (KG) =
<pre>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

)

)</pre>
|
* '''Total Revenue in Euro''' – Calculates the total revenue by summing all values in Euro from the combined quotations table.

* '''CHW (KG)''' – Calculates the total chargeable weight in kilograms, converting from Lb when needed.
|-
|2'''.Total Revenue by Week Numbers and Entity'''
|Total Revenue In euro =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
|This is a table that displays weekly Revenue in EUR and CHW(KG) across different entities.
|}

Weight v Revenue Week-On-Week

2025-10-01T13:23:23Z

Stanley.songok: /* Calculations */

Weight v Revenue Week-On-Week

2025-10-01T13:19:40Z

Stanley.songok: /* Data Transformation Applied */

Weight v Revenue Week-On-Week

2025-10-01T13:18:28Z

Stanley.songok: /* Filters */

Weight v Revenue Week-On-Week

2025-10-01T13:17:06Z

Stanley.songok: /* Summary */

== Summary ==
The Weight vs Revenue Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays weekly revenue by entities.

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|
|
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}

Weight v Revenue Week-On-Week

2025-10-01T13:15:45Z

Stanley.songok: /* Summary */

== Summary ==
The Weight vs Revenue Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays weekly revenue by entities

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|
|
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}

Yield Week-On-Week

2025-10-01T13:00:49Z

Stanley.songok: /* Calculations */

== 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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!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.
|}

Yield Week-On-Week

2025-10-01T12:54:07Z

Stanley.songok: /* Calculations */

Yield Week-On-Week

2025-10-01T12:47:10Z

Stanley.songok: /* Data Transformation Applied */

Yield Week-On-Week

2025-10-01T12:44:31Z

Stanley.songok: /* Filters */

Yield Week-On-Week

2025-10-01T12:42:27Z

Stanley.songok: /* Summary */

== 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 ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|
|
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}

Yield - Group Overview

2025-10-01T09:36:21Z

Stanley.songok:

== 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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. '''Total Yield And Group Target By Year'''
|GroupTarget = 1.73
TotalYield =
<pre>IF ( AND ( [Chargeable Weight] > 0, [Total Revenue In euro] > 0 ), [Total Revenue In euro] / [Chargeable Weight] )</pre>
|
* '''Group Target''' – Estimated average yield target across all sites.

* '''Total Yield''' – Calculated by dividing revenue by chargeable weight.
|-
|2. '''Monthly Figures'''
|Total Revenue =

<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>

|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 =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>
|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 =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>CHW (KG) =

<pre>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

)

)</pre>
|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 =
<pre>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()

)</pre>
|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 =
<pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>
CHW (KG) =
<pre>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

)

)</pre>
|This is a line chart that displays revenue (EUR) and Chargeable Weights by their respective months.
|}

Yield - Group Overview

2025-10-01T09:34:11Z

Stanley.songok:

Yield - Group Overview

2025-10-01T09:24:39Z

Stanley.songok:

== 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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!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 ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|1. '''Total Yield And Group Target By Year'''
|GroupTarget = 1.73
TotalYield =
<pre>IF ( AND ( [Chargeable Weight] > 0, [Total Revenue In euro] > 0 ), [Total Revenue In euro] / [Chargeable Weight] )</pre>
|
* '''Group Target''' – Estimated average yield target across all sites.

* '''Total Yield''' – Calculated by dividing revenue by chargeable weight.
|-
|2. '''Monthly Figures'''
|Total Revenue =

<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>

|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 =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>
|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 =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>CHW (KG) =

<pre>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

)

)</pre>
|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'''
|Target Yield =
<pre>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()

)</pre>
|
|}

Yield - Group Overview

2025-10-01T09:14:04Z

Stanley.songok:

Yield - Group Overview

2025-10-01T09:01:44Z

Stanley.songok:

Yield - Group Overview

2025-10-01T08:59:35Z

Stanley.songok: /* Calculations */

Yield - Group Overview

2025-10-01T08:45:31Z

Stanley.songok: /* Calculations */

Yield - Group Overview

2025-10-01T08:40:33Z

Stanley.songok: /* Data Transformation Applied */

Yield - Group Overview

2025-10-01T08:24:16Z

Stanley.songok: /* Filters */

Yield - Group Overview

2025-10-01T08:13:39Z

Stanley.songok: