I am a tableau developer, but I know Python, stats, and, in short, I think you all will be best able to solve my problem.
- There is a universal filter on Facility. This means that any dataset/sheet can only have one field equal to facility.
- Data table looks like this: [Time] [Departure=facilities] [Arrival=facilities]
- Departure and Arrival are both fields that contain facility names. The goal is to make a chart that shows the quantity of arrivals and departures for a chosen facility (let's say, by hour... my times are exact to the second but I'm willing to bin to fix my problem. Also, time does apply to both departure airport and arrival; it's a chosen time by FAA to describe the flight).
- How can I transform this dataset so that there is only one field designated as facility? Facility can only be one column, but I need the quantities of arrivals and departures. One more catch: this is a live data stream. I am not reshaping for data analysis, this is real-time. My fields need to be calculated fields (they can include the names of the original fields, and the calculations can include anything that you can think of in excel... there are equal if not more available functions in tableau, but the language is slightly different;cI figure more people would be able to help if I said "feel free to write the calculated fields as you would in excel" because I can easily translate any differences myself. Any input from any sort of expertise is appreciated! Even the "theory" to describe how this would be done eludes me, so please offer any thoughts.