View source for Weight By Carrier


== 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.
|}