Weight v Revenue Week-On-Week: Difference between revisions
| Line 67: | Line 67: | ||
!Description | !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> | |||
| | | | ||
|} | |} | ||
Revision as of 14:23, 1 October 2025
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
| 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.Revenue and CHW(KG) by Week Number | 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 ) ) |