View source for Datacair EY Performance Report - Detail

== Summary ==

This table presents a weekly snapshot of cargo operations performance, displaying Current Week, Previous Week, and Week-over-Week (WoW) changes for key metrics including AWBs, Executed AWBs, Pending AWBs, CAMS Raised, Completion Rate (CR), and Completion Rate (CR-EY).

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|Station
|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).
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|EY Performance Report
|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).
|}

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