You can make a calculated field like this;
case [Departure Airport]
when 'ATL' then [Departure Airport]
when 'CLT' then [Departure Airport]
when 'DEN' then [Departure Airport]
when 'DFW' then [Departure Airport]
when 'JFK' then [Departure Airport]
when 'LAS' then [Departure Airport]
when 'LAX' then [Departure Airport]
when 'MIA' then [Departure Airport]
when 'ORD' then [Departure Airport]
when 'SFO' then [Departure Airport]
Use it on the Rows and Filters instead of the Departure Airport dimension.
You will have to Sort it manually , to get Overseas at the end.
AmericanFlights(mc).twbx 9.5 MB
I appreciate your help Michel, so please don't let my comments make you think I don't.
This method seems a very hard coded (I'm using the term quite flippantly as I am by no means a techie expert) method right? It gets the job done, but if I wanted to have say for example 20 airports in my non-overseas category wouldn't it make modifying this a bit more time consuming?
I'd like to leave this discussion open still to pick up any extra tips / ideas on how to resolve this issue as there are often multiple ways to do the same thing each with advantages and disadvantages.
I'll use your method for the time being but hopefully there is potentially an even better way.
Also if for example there is a week in the data where MIA doesn't have any flights e.g 12th January 2015. I would like to force Tableau to show this column still with the value of MIA and Flights 0. I have been trying to google it and I thought the Weekly Flights Calculated field would address this with:
IF COUNT([Departure Airport])>0 THEN COUNT([Departure Airport])
But it still doesn't show...Googling it led me to a forum post which said I should pad the data with null values. I would rather not touch the raw data prior to it going into Tableau if possible, so is there another way to do this?