Job Finder - Revision history

Stanley.songok: /* Calculations */

2025-10-02T13:03:10Z

Calculations

← Older revision		Revision as of 15:03, 2 October 2025
Line 74:		Line 74:
	\|Total Revenue In euro =<pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>		\|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.		\|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.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T12:57:51Z

Calculations

← Older revision		Revision as of 14:57, 2 October 2025
Line 70:		Line 70:
	\|Total Revenue In euro = <pre>SUM('Combined Quatations Tables2'[Revenue In EURO])</pre>		\|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.		\|'''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.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T12:56:05Z

Calculations

← Older revision		Revision as of 14:56, 2 October 2025
Line 68:		Line 68:
	\|-		\|-
	\|1. '''Monthly Figures'''		\|1. '''Monthly Figures'''
	\|Total Revenue In euro = SUM('Combined Quatations Tables2'[Revenue In EURO])		\|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.		\|'''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.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-10-02T12:55:33Z

Calculations

← Older revision		Revision as of 14:55, 2 October 2025
Line 67:		Line 67:
	!Description		!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.
	\|}		\|}

Stanley.songok: /* Data Transformation Applied */

2025-10-02T12:51:31Z

Data Transformation Applied

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

Stanley.songok: /* Filters */

2025-10-02T12:50:31Z

Filters

@@ Line 9: / Line 9: @@
 !Description
 |-
+|'''Database'''
+|Select the reporting database.
-|}
+|-
 == Data Transformation Applied ==

Stanley.songok: /* Summary */

2025-10-02T12:49:09Z

Summary

← Older revision		Revision as of 14:49, 2 October 2025
Line 1:		Line 1:

	== Summary ==		== Summary ==
	~~This is for the page "~~Job Finder" page ~~that~~ is a part of the Yield, Weight and Revenue GSA ~~Report~~.		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 ==		== Filters ==

David.weller: Created page with " == Summary == This is for the page "Job Finder" 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:22Z

Created page with " == Summary == This is for the page "Job Finder" 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 "Job Finder" 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
|-
|
|
|
|}