Site Summary - Revision history

Stanley.songok: /* Calculations */

2025-10-02T12:41:38Z

Calculations

← Older revision		Revision as of 14:41, 2 October 2025
Line 203:		Line 203:

	* '''Chargeable Weight by Month/Year''' – Displays the total chargeable weight 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.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T12:26:49Z

Calculations

← Older revision		Revision as of 14:26, 2 October 2025
Line 161:		Line 161:

	* '''Total Revenue Site''' – Sums up all revenue values for the selected site.		* '''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.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T11:58:59Z

Calculations

← Older revision		Revision as of 13:58, 2 October 2025
Line 158:		Line 158:
	Total Revenue Site = <pre>SUM('Combined Quatations Tables2'[Revenue2])</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.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T11:52:21Z

Calculations

← Older revision		Revision as of 13:52, 2 October 2025
Line 139:		Line 139:
	\|2. '''Total Revenue and Chargeable Weight By Date'''		\|2. '''Total Revenue and Chargeable Weight By Date'''
	\|CHW (KG) =		\|CHW (KG) =
	SUMX (		<pre>SUMX (

	'Combined Quatations Tables2',		'Combined Quatations Tables2',
Line 153:		Line 153:
	)		)

	)		)</pre>


	Total Revenue Site = SUM('Combined Quatations Tables2'[Revenue2])		Total Revenue Site = <pre>SUM('Combined Quatations Tables2'[Revenue2])</pre>
	\|		\|
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T11:47:20Z

Calculations

← Older revision		Revision as of 13:47, 2 October 2025
Line 136:		Line 136:

	* '''Target Yield''' – Uses preset target values for each site (based on the database and site name) to define the expected yield benchmark for comparison.		* '''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) =
			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

			)

			)


			Total Revenue Site = SUM('Combined Quatations Tables2'[Revenue2])
			\|
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T10:17:59Z

Calculations

← Older revision		Revision as of 12:17, 2 October 2025
Line 133:		Line 133:
	BLANK()</pre>		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.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T10:11:45Z

Calculations

@@ Line 71: / Line 71: @@
 !Description
 |-
+|1. '''Total Yield&Target Yield By Date'''
+|TotalYield Site =
+|
 |}

Stanley.songok: /* Data Transformation Applied */

2025-10-02T10:05:18Z

Data Transformation Applied

@@ Line 44: / Line 44: @@
 !Transformations
 |-
+|
+* '''Formatting''' – Data is arranged into a consistent structure used across all report pages.
 |}

Stanley.songok: /* Summary */

2025-10-02T10:04:32Z

Summary

@@ Line 1: / Line 1: @@
 == Summary ==
-This is for the page "Site Summary" page that is a part of the Yield, Weight and Revenue GSA Report.
+The Site Summary page is part of the Yield, Weight, and Revenue report. It includes site currencies and displays data across various carriers.
 == Filters ==
@@ Line 9: / Line 9: @@
 !Description
 |-
+|'''Database'''
+|Select the reporting database.
 |}
 == Data Transformation Applied ==

David.weller: Created page with " == Summary == This is for the page "Site Summary" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

2025-09-30T10:20:10Z

Created page with " == Summary == This is for the page "Site Summary" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

New page

== Summary ==
This is for the page "Site Summary" page that is a part of the Yield, Weight and Revenue GSA Report.

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

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

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