Graded Lab - Oct 30

• Create a new sheet Lab6Part1
• Create a Straight Table.
  • Dimension: Aircraft Name
  • Expressions:
    1. $(eLoadFactor) (Make sure that variable is still exist in your application, and if not, add it, with the following value:
       (Sum ([# Transported Passengers]) / Sum ([# Available Seats]))
       Number formating: fixed to 2 decimal, show percent
    2. $(eLoadFactor) - Linear Gauge with 2-3 segments (your choice). Create variables for the lower bounds and slider object to change variable values (you can use variables we already created for similar cases)
    3. $(eAirTime)
       Number formating: fixed to 2 decimal, show percent
    4. $(eEnplanedPassengers)
    5. $(eEnplanedPassengers) Mini Chart, Dimension: Period
       Create a separate Line Chart for the same expression and Dimension Period and compare charts for one of the Aircraft names of your choice
  • Add Visual Cues to eAirTime and eLoadFactor using variables. Create slider to change variable values

  • Create new sheet Lab6PartII
  • Create Bar Chart to compare # Transported Passengers in PHL - Philadelphia International Airport (as origin City) in two consecutive years.
    • Dimension: Carrier Name
    • Use the following for Expressions:

      Sum({$<[Origin Airport Code] = {'PHL'},Year = {$(=Max(Year))}>} [# Transported Passengers])

      Sum({$<[Origin Airport Code] = {'PHL'},Year = {$(=Max(Year)-1)}>} [# Transported Passengers])

    • Format the chart to display data in decreasing order for 10 largest carriers. (Bonus: display data for a specific number of carriers. Make it a variable and use it on Dimension Limits Tab and create a slider to change the value).
    • Add additional restrictions: Carrier's Operating Region, Carrier Group and Flight Type (use List Boxes) in your analysis