View source for Weight v Revenue Week-On-Week


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