Click on the “brick” to see how the delays were distributed during the year.
The Union-wide capacity target is set for each year of the reference period 2 (RP2) at 0.5 minutes of average ATFM delay per flight (green color is below the target).
The phone version is available here.
Data pre-aggregation
The great thing about this visualisation was that I spent only minimal time preparing the data, I only aggreated the En-route IFR flights and ATFM delays dataset from EUROCONTROL in a pivot table, which reduced the file size from 20MB to 0.5 and added calculated field(s) in Tableau to divide the delay figures by the number of flights.