Datacair EY Performance Report - Airway Bills - Revision history

Stanley.songok: /* Calculations */

2026-02-04T08:32:31Z

Calculations

@@ Line 45: / Line 45: @@
 !Description
 |-
-|TBC
+|1. Total AWBs
-|TBC
+|Sum of all AWBs
-|TBC
+|Total number of Air Waybills created in the selected period
 |-
 |}

Stanley.songok: /* Data Transformation Applied */

2026-02-04T08:31:49Z

Data Transformation Applied

← Older revision		Revision as of 10:31, 4 February 2026
Line 22:		Line 22:
	!Transformations		!Transformations
	\|-		\|-
	\|~~TBC~~		\|EY Performance Report
	\|~~TBC~~		\|Cleaned the dataset by correcting column data types (dates, numbers, text) to ensure accurate calculations and filtering.
	\|-		\|-
			\|Pending AWBs
			\|Standardized data types and prepared the table for relationship mapping with Stations.
			\|-
			\|Reopened AWBs
			\|Corrected data types and validated station identifiers for consistent joins.
			\|-
			\|Stations
			\|Used as a master reference table to provide station details for all operational datasets.
			\|-
			\|Calendar
			\|Created and linked to date fields to support time-based analysis (weekly and monthly trends).
	\|}		\|}

Stanley.songok: /* Filters */

2026-02-04T08:30:59Z

Filters

← Older revision		Revision as of 10:30, 4 February 2026
Line 9:		Line 9:
	!Description		!Description
	\|-		\|-
	\|~~TBC~~		\|Station
	\|~~TBC~~		\|Filters the report to show data for a specific cargo station or location. Helps compare performance across stations
	\|-		\|-
			\|Date
			\|Filters data by selected date range to analyze performance for a specific period (week, month, or custom range).
	\|}		\|}

Stanley.songok: /* Summary */

2026-02-04T08:30:11Z

Summary

← Older revision		Revision as of 10:30, 4 February 2026
Line 1:		Line 1:
	== Summary ==		== Summary ==

	~~TBC~~		This table provides an overview of Air Waybill (AWB) status by highlighting pending and reopened AWBs along with their raised and resolved dates. It helps teams track outstanding issues, monitor resolution timelines, and identify delays in the AWB handling process to support timely follow-up and operational efficiency.

	== Filters ==		== Filters ==

David.weller: Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ !Filter !Description |- |TBC |TBC |- |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |TBC |TBC |- |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |TBC |TBC |TBC |- |}"

2026-01-29T10:58:38Z

Created page with "== Summary == TBC == Filters == {| class="wikitable" |+ !Filter !Description |- |TBC |TBC |- |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- |TBC |TBC |- |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- |TBC |TBC |TBC |- |}"

New page

== Summary ==

TBC

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

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

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