Spot Rate Report - Revision history

Stanley.songok at 07:54, 18 June 2025

2025-06-18T07:54:45Z

← Older revision		Revision as of 09:54, 18 June 2025
Line 127:		Line 127:
	*Ensures the measure returns a numeric value: The + 0 ensures that the measure does not return a blank value in cases where no records match the criteria.		*Ensures the measure returns a numeric value: The + 0 ensures that the measure does not return a blank value in cases where no records match the criteria.
	\|-		\|-
	\| 5.Table Breakdown By Total cost & sell\|\| <pre>SUM('Global quotation Spot Rate'[Total Cost])</pre>		\| 5.Table Breakdown By Total cost & sell\|\| <pre> Total Cost=SUM('Global quotation Spot Rate'[Total Cost])</pre>
	\|\| This table provides a breakdown of total cost and total sell for each Master Air Waybill (MAWB) by carrier. The Total Cost measure sums up all shipment costs using SUM('Global quotation Spot Rate'[Total Cost]), while the Total Sell measure calculates the total revenue using SUM('Global quotation Spot Rate'[Total Sell]). This helps track shipment expenses, monitor revenue, compare costs versus sell prices, and analyse carrier performance in terms of pricing.		\|\| This table provides a breakdown of total cost and total sell for each Master Air Waybill (MAWB) by carrier. The Total Cost measure sums up all shipment costs using SUM('Global quotation Spot Rate'[Total Cost]), while the Total Sell measure calculates the total revenue using SUM('Global quotation Spot Rate'[Total Sell]). This helps track shipment expenses, monitor revenue, compare costs versus sell prices, and analyse carrier performance in terms of pricing.
	\|}		\|}

Stanley.songok: /* Calculations */

2025-06-18T07:53:11Z

Calculations

← Older revision		Revision as of 09:53, 18 June 2025
Line 26:		Line 26:
	!Calculation		!Calculation
	!Description		!Description
	\|
	\|-		\|-
	\| 1.\|\| \|\| This clustered column chart displays the monthly trends for Total Spot Rate Quotes, Total Spot Rate Bookings, and Total Spot Rate Confirmed.		\| 1.Monthly Trend by Spot Rate\|\|Formula:
			<pre>Total Spot Rate Quotes =
	\|-
	\|		CALCULATE(

			COUNTROWS('Global quotation Spot Rate'),

			FILTER(

			'Global quotation Spot Rate',

			'Global quotation Spot Rate'[spotrate] = 1 &&

			NOT(ISBLANK('Global quotation Spot Rate'[quoted_at])) </pre>
			\|\| This clustered column chart displays the monthly trends for Total Spot Rate Quotes, Total Spot Rate Bookings, and Total Spot Rate Confirmed.
	\|-		\|-
	\| 2. Total Spot Rate Quotes. \|\|Formula:		\| 2. Total Spot Rate Quotes. \|\|Formula:
	Total Spot Rate Quotes =		<pre> Total Spot Rate Quotes =

	CALCULATE(		CALCULATE(
Line 46:		Line 56:
	'Global quotation Spot Rate'[spotrate] = 1 &&		'Global quotation Spot Rate'[spotrate] = 1 &&

	NOT(ISBLANK('Global quotation Spot Rate'[quoted_at]))		NOT(ISBLANK('Global quotation Spot Rate'[quoted_at]))</pre>
	\|\|		\|\|
	* Counts the number of spot rate quotes: It counts the rows in the 'Global quotation Spot Rate' table where the quote is classified as a spot rate (spotrate = 1).		* Counts the number of spot rate quotes: It counts the rows in the 'Global quotation Spot Rate' table where the quote is classified as a spot rate (spotrate = 1).
Line 59:		Line 69:

	This measure helps track the total number of valid spot rate quotes within a specific date range, providing insights into the volume of quotations generated.		This measure helps track the total number of valid spot rate quotes within a specific date range, providing insights into the volume of quotations generated.
	\|-
	\|
	\|-		\|-
	\| 3. Total Spot Rate Bookings.\|\|Formula:		\| 3. Total Spot Rate Bookings.\|\|Formula:
	Total Spot Rate Bookings =		<pre>Total Spot Rate Bookings =

	CALCULATE(		CALCULATE(
Line 79:		Line 87:
	)		)

	) + 0		) + 0 </pre>
	\|\|		\|\|
	* Counts the number of spot rate quotes: It counts the rows in the 'Global quotation Spot Rate' table where the quote is classified as a spot rate (spotrate = 1).		* Counts the number of spot rate quotes: It counts the rows in the 'Global quotation Spot Rate' table where the quote is classified as a spot rate (spotrate = 1).
Line 93:		Line 101:

	This measure helps track the total number of Total spot rate bookings within a specific date range,		This measure helps track the total number of Total spot rate bookings within a specific date range,

	\|-
	\|
	\|-		\|-
	\| 4. Total Spot Rate Confirmed\|\|Formula:		\| 4. Total Spot Rate Confirmed\|\|Formula:
	Total Spot Rate Confirmed =		<pre>Total Spot Rate Confirmed =

	CALCULATE(		CALCULATE(
Line 114:		Line 119:
	)		)

	) + 0		) + 0 </pre>
	\|\|		\|\|
	* Counts the number of spot rate quotes: It counts the rows in the 'Global quotation Spot Rate' table where the quote is classified as a spot rate (spotrate = 1).		* Counts the number of spot rate quotes: It counts the rows in the 'Global quotation Spot Rate' table where the quote is classified as a spot rate (spotrate = 1).
Line 122:		Line 127:
	*Ensures the measure returns a numeric value: The + 0 ensures that the measure does not return a blank value in cases where no records match the criteria.		*Ensures the measure returns a numeric value: The + 0 ensures that the measure does not return a blank value in cases where no records match the criteria.
	\|-		\|-
	\|		\| 5.Table Breakdown By Total cost & sell\|\| <pre>SUM('Global quotation Spot Rate'[Total Cost])</pre>
	\|-		\|\| This table provides a breakdown of total cost and total sell for each Master Air Waybill (MAWB) by carrier. The Total Cost measure sums up all shipment costs using SUM('Global quotation Spot Rate'[Total Cost]), while the Total Sell measure calculates the total revenue using SUM('Global quotation Spot Rate'[Total Sell]). This helps track shipment expenses, monitor revenue, compare costs versus sell prices, and analyse carrier performance in terms of pricing.
	\| 5.\|\| \|\| This table provides a breakdown of total cost and total sell for each Master Air Waybill (MAWB) by carrier. The Total Cost measure sums up all shipment costs using SUM('Global quotation Spot Rate'[Total Cost]), while the Total Sell measure calculates the total revenue using SUM('Global quotation Spot Rate'[Total Sell]). This helps track shipment expenses, monitor revenue, compare costs versus sell prices, and analyse carrier performance in terms of pricing.
	\|}		\|}

Stanley.songok: /* Filters */

2025-06-17T13:30:36Z

Filters

← Older revision		Revision as of 15:30, 17 June 2025
Line 8:		Line 8:
	! style="width: 75%;" \|Description		! style="width: 75%;" \|Description
	\|-		\|-
	\|~~TBC~~		\|Database\|\|If you have access to multiple entity databases, you can filter and select specific ones.
	\|~~TBC~~		\|-
			\|Site\|\|Allows you to filter and focus on specific sites within your entity access.
			\|-
			\|Carrier\|\|Enables filtering by carriers associated with the sites you have access to.
			\|-
			\|Users\|\|Filters quotes/bookings by specific users. Users will be listed if they have access to the sites you can access.
			\|-
			\|Date Filter\|\|Displays only jobs created within the specified date range.
	\|}		\|}

Stanley.songok: /* Summary */

2025-06-17T13:23:41Z

Summary

← Older revision		Revision as of 15:23, 17 June 2025
Line 1:		Line 1:
	== Summary ==		== Summary ==
	~~TBC~~		This is a report that shows you a breakdown of the spot rates in the system

	== Filters ==		== Filters ==

Stanley.songok at 07:33, 30 May 2025

2025-05-30T07:33:49Z

← Older revision		Revision as of 09:33, 30 May 2025
Line 84:		Line 84:

	Purpose		Purpose

	This measure helps track the total number of Total spot rate bookings within a specific date range,		This measure helps track the total number of Total spot rate bookings within a specific date range,

Stanley.songok at 07:33, 30 May 2025

2025-05-30T07:33:16Z

← Older revision		Revision as of 09:33, 30 May 2025
Line 82:		Line 82:


	Purpose
			Purpose
	This measure helps track the total number of Total spot rate bookings within a specific date range,		This measure helps track the total number of Total spot rate bookings within a specific date range,

Stanley.songok at 07:29, 30 May 2025

2025-05-30T07:29:42Z

@@ Line 21: / Line 21: @@
+|
 |-
-| 3.|| || The table breaks down pre quotes created over Time by Mailbox
+| 1.|| || This clustered column chart displays the monthly trends for Total Spot Rate Quotes, Total Spot Rate Bookings, and Total Spot Rate Confirmed.
 |-
+|
 |-
-| 3.|| || The table breaks down pre quotes created over Time by Mailbox
+| 2. Total Spot Rate Quotes. ||Formula:
 |-
+|
 |-
-| 3.|| || The table breaks down pre quotes created over Time by Mailbox
+| 3.  Total Spot Rate Bookings.||Formula:
 |-
+|
 |-
-| 3.|| || The table breaks down pre quotes created over Time by Mailbox
+| 4. Total Spot Rate Confirmed||Formula:
 |-
+|
 |-
-| 3.|| || The table breaks down pre quotes created over Time by Mailbox
+| 5.|| ||  This table provides a breakdown of total cost and total sell for each Master Air Waybill  (MAWB) by carrier. The Total Cost measure sums up all shipment costs using SUM('Global quotation Spot Rate'[Total Cost]), while the Total Sell measure calculates the total revenue using SUM('Global quotation Spot Rate'[Total Sell]). This helps track shipment expenses, monitor revenue, compare costs versus sell prices, and analyse carrier performance in terms of pricing.
-|-
+|}

Stanley.songok at 12:26, 29 May 2025

2025-05-29T12:26:57Z

@@ Line 19: / Line 19: @@
 !Calculation
 !Description
 |-
+|
+|
+|
-|}
+|-

David.weller: Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ ! style="width: 25%;" |Filter ! style="width: 75%;" |Description |- |TBC |TBC |} == Calculations == 800x800px {| class="wikitable" |+ !Reference !Calculation !Description |- | | | |}"

2025-05-27T14:41:23Z

Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ ! style="width: 25%;" |Filter ! style="width: 75%;" |Description |- |TBC |TBC |} == Calculations == none|thumb|800x800px {| class="wikitable" |+ !Reference !Calculation !Description |- | | | |}"

New page

== Summary ==
TBC

== Filters ==
{| class="wikitable"
|+
! style="width: 25%;" |Filter
! style="width: 75%;" |Description
|-
|TBC
|TBC
|}

== Calculations ==
[[File:Spot Rate Report.png|none|thumb|800x800px]]
{| class="wikitable"
|+
!Reference
!Calculation
!Description
|-
|
|
|
|}