Teams Dashboard - Revision history

Stanley.songok at 09:26, 17 June 2025

2025-06-17T09:26:44Z

← Older revision		Revision as of 11:26, 17 June 2025
Line 231:		Line 231:

	iii. CW Quote		iii. CW Quote
	*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total chargeable weight for the items being quoted.		*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total chargeable weight for the items being quoted.

	*Checks for a valid quote: It ensures that only rows where the quoted_at column is not blank are included. This means it only considers rows where a quotation has been provided.		*Checks for a valid quote: It ensures that only rows where the quoted_at column is not blank are included. This means it only considers rows where a quotation has been provided.
Line 242:		Line 242:

	iv. GW Quote.		iv. GW Quote.
	This measure calculates the total gross weight for all quotations that have been quoted.		This measure calculates the total gross weight for all quotations that have been quoted.
	*Sum of gross weight: It sums the values from the gross_weight column in the quotations table, representing the total weight of items in the quotations, including packaging and any additional weight.		*Sum of gross weight: It sums the values from the gross_weight column in the quotations table, representing the total weight of items in the quotations, including packaging and any additional weight.

Stanley.songok at 09:25, 17 June 2025

2025-06-17T09:25:21Z

← Older revision		Revision as of 11:25, 17 June 2025
Line 218:		Line 218:

	This measure helps you track the total chargeable weight for all bookings within a specific date range.		This measure helps you track the total chargeable weight for all bookings within a specific date range.

	ii. GW Booking		ii. GW Booking
	including any packaging or additional weight.		including any packaging or additional weight.
Line 228:		Line 229:

	This measure helps track the total gross weight of all bookings within a specific date range.		This measure helps track the total gross weight of all bookings within a specific date range.

	iii. CW Quote		iii. CW Quote
	*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total chargeable weight for the items being quoted.		*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total chargeable weight for the items being quoted.
Line 238:		Line 240:

	This measure helps you track the total chargeable weight for all quotations within a specific date range		This measure helps you track the total chargeable weight for all quotations within a specific date range
	iv. GW Quote.
			iv. GW Quote.
	This measure calculates the total gross weight for all quotations that have been quoted.		This measure calculates the total gross weight for all quotations that have been quoted.
	*Sum of gross weight: It sums the values from the gross_weight column in the quotations table, representing the total weight of items in the quotations, including packaging and any additional weight.		*Sum of gross weight: It sums the values from the gross_weight column in the quotations table, representing the total weight of items in the quotations, including packaging and any additional weight.

Stanley.songok at 09:17, 17 June 2025

2025-06-17T09:17:23Z

← Older revision		Revision as of 11:17, 17 June 2025
Line 175:		Line 175:
	\| 8		\| 8

	\|\|a. CW booking		\|\|i. CW booking
	<pre>CW_Booking =		<pre>CW_Booking =
	CALCULATE (		CALCULATE (
Line 184:		Line 184:

	USERELATIONSHIP (DimDate [Date], quotations[booked_at]) )</pre>		USERELATIONSHIP (DimDate [Date], quotations[booked_at]) )</pre>
	\|\|		ii. GW Booking
			<pre> GW Booking =
			CALCULATE (
			SUM (quotations[gross_weight]),
			NOT (ISBLANK (quotations[booked_at])),
			USERELATIONSHIP (DimDate [Date], quotations[booked_at])) </pre>
			iii. CW Quote
			<pre> CW_Quote =

			CALCULATE (

			SUM (quotations[chargeable_weight]),

			NOT (ISBLANK (quotations[quoted_at])),

			USERELATIONSHIP (DimDate [Date], quotations[quoted_at])) </pre>
			iv. GW Quote
			<pre> GW Quote =

			CALCULATE (

			SUM (quotations[gross_weight]),
			NOT (ISBLANK (quotations[quoted_at])),
			USERELATIONSHIP (DimDate [Date], quotations[quoted_at])) </pre>
			\|\| i.CW booking
	*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total weight of items for bookings.		*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total weight of items for bookings.

Line 193:		Line 217:
	Purpose		Purpose

	This measure helps you track the total chargeable weight for all bookings within a specific date range.		This measure helps you track the total chargeable weight for all bookings within a specific date range.
	\|-		ii. GW Booking
	~~\| \|\| b~~. GW Booking		including any packaging or additional weight.
	~~<pre>GW Booking =~~
	~~CALCULATE (~~
	~~SUM (quotations[gross_weight]),~~

	~~NOT (ISBLANK (quotations[booked_at])),~~

	~~USERELATIONSHIP (DimDate [Date], quotations[booked_at])) </pre>~~
	\|\|
	*Sum of gross weight: It sums the values from the gross_weight column in the quotations table, representing the total weight of items for bookings, including any packaging or additional weight.

	*Checks for a valid booking: It ensures that only rows where the booked_at column is not blank are included. This means it only considers rows where a booking has been successfully made.		*Checks for a valid booking: It ensures that only rows where the booked_at column is not blank are included. This means it only considers rows where a booking has been successfully made.
Line 212:		Line 227:
	Purpose		Purpose

	This measure helps track the total gross weight of all bookings within a specific date range.		This measure helps track the total gross weight of all bookings within a specific date range.
	\|-		iii. CW Quote
	~~\| \|\| c~~. CW Quote ~~<pre>CW_Quote =~~		*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total chargeable weight for the items being quoted.
	~~CALCULATE (~~

	~~SUM (quotations[chargeable_weight]),~~

	~~NOT (ISBLANK (quotations[quoted_at])),~~
	~~USERELATIONSHIP (DimDate [Date], quotations[quoted_at])) </pre>~~
	\|\|
	*Sum of chargeable weight: It sums the values from the chargeable_weight column in the quotations table, representing the total chargeable weight for the items being quoted.

	*Checks for a valid quote: It ensures that only rows where the quoted_at column is not blank are included. This means it only considers rows where a quotation has been provided.		*Checks for a valid quote: It ensures that only rows where the quoted_at column is not blank are included. This means it only considers rows where a quotation has been provided.
Line 230:		Line 237:
	Purpose		Purpose

	This measure helps you track the total chargeable weight for all quotations within a specific date range		This measure helps you track the total chargeable weight for all quotations within a specific date range
	\|-		iv. GW Quote.
	\| ~~\|\|d~~. GW Quote.		This measure calculates the total gross weight for all quotations that have been quoted.
	~~<pre>GW Quote =~~
	~~CALCULATE (~~

	~~SUM (~~quotations~~[gross_weight]),~~
	~~NOT (ISBLANK (quotations[quoted_at])),~~
	~~USERELATIONSHIP (DimDate [Date], quotations[quoted_at]))</pre>~~
	\|\|
	*Sum of gross weight: It sums the values from the gross_weight column in the quotations table, representing the total weight of items in the quotations, including packaging and any additional weight.		*Sum of gross weight: It sums the values from the gross_weight column in the quotations table, representing the total weight of items in the quotations, including packaging and any additional weight.

	*Checks for a valid quote: It ensures that only rows where the quoted_at column is not blank are included. This means it only considers rows where a quotation has been provided		*Checks for a valid quote: It ensures that only rows where the quoted_at column is not blank are included. This means it only considers rows where a quotation has been provided

	\|-		\|-
	\| 9 - Total \|\|Formula:		\| 9 - Total \|\|Formula:

Stanley.songok at 08:52, 17 June 2025

2025-06-17T08:52:04Z

@@ Line 269: / Line 269: @@
   || This measure calculates the conversion rate for SpotRate, which is the ratio of  Won bookings to Total quotations
 |-
-| 12 || || This table shows the chargeable weight breakdown across Total Bookings, Total Quotes, Direct Bookings, Converted Bookings, and Conversion Rate
+| 12. WeightBreakChar || <pre>WeightBreakChar =
 |-
-| 13 || || This table displays the tasks completed by the user, including Total Bookings, Total Quotes, Direct Bookings, Converted Bookings, and the Conversion Rate.
+| 13. Total Bookings By User || <pre>Total Bookings =
 |-
-| 14 || || Clustered bar chart breakdown total booking by customers.
+| 14. Total Bookings By Customer ||<pre>Total Bookings =
 |-
-| 15 || || The clustered bar chart breakdown total booking by Service
+| 15. Total Bookings By Service ||<pre>Total Bookings =
 |-
-| 16 || || The clustered bar chart breakdown total bookings by Teams.
+| 16. Total Bookings By Teams || <pre>Total Bookings =
 |}

Stanley.songok: /* Calculations */

2025-06-16T13:23:39Z

Calculations

← Older revision		Revision as of 15:23, 16 June 2025
Line 31:		Line 31:
	!Calculation		!Calculation
	!Description		!Description
	\|
	\|
	\|
	\|
	\|-		\|-
	\| 1 - Total Pre-quotes. \|\|Formula:		\| 1 - Total Pre-quotes. \|\|Formula:

Stanley.songok: /* Calculations */

2025-06-16T13:21:58Z

Calculations

Show changes

Stanley.songok: /* Filters */

2025-06-16T12:59:47Z

Filters

← Older revision		Revision as of 14:59, 16 June 2025
Line 9:		Line 9:
	! 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.
			\|-
			\|Origin \|\|Filters jobs based on their origin location.
			\|-
			\|Destination \|\|Filters jobs based on their destination location
			\|-
			\| Date Filter\|\|Displays only jobs created within the specified date range.
	\|}		\|}

Stanley.songok: /* Summary */

2025-06-16T12:49:05Z

Summary

← Older revision		Revision as of 14:49, 16 June 2025
Line 1:		Line 1:

	== Summary ==		== Summary ==
	~~TBC~~		This page provides a detailed overview of all pre-quotes, quotes, bookings, and direct bookings made within the specified date range but from a user / team and operations perspective.

	== Filters ==		== Filters ==

Stanley.songok at 12:32, 28 May 2025

2025-05-28T12:32:15Z

Show changes

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:21:18Z

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:M&W TEAMS DASHBOARD.png|none|thumb|800x800px]]
{| class="wikitable"
|+
!Reference
!Calculation
!Description
|-
|
|
|
|}