Databases Reference
In-Depth Information
• Percentage versus the carrier's whole:
Sum([# Departures Performed]) / Sum(TOTAL <[Carrier Group],
Airline> [# Departures Performed])
This one will return the percentage of flights for a particular carrier, month,
and year relative to the total flights performed by that carrier in all years and
months available in the current selection state.
• Percentage versus the carrier's whole per year:
Sum([# Departures Performed]) / Sum(TOTAL <[Carrier Group],
Airline, Year> [# Departures Performed])
This will return the percentage of flights for a particular carrier, month, and
year relative to the total flights performed by that carrier in that year, but
for all months available in the current selection state that correspond to that
same year.
The result is shown in the following screenshot:
