Jason Millett 2 Posted July 15, 2020 Share Posted July 15, 2020 I have a data set for Plane Schedules. It has Flight ID, Scheduled departure date time and scheduled arrival date time In the data set below the number of planes I have in the air for each hour: 14:00 to 15:00 = 2 15:00 to 16:00 = 3 16:00 to 17:00 = 3 17:00 to 18:00 = 3 18:00 to 19:00 = 3 19:00 to 20:00 = 3 20:00 to 21:00 = 2 21:00 to 22:00 = 1 So how can I best visualize the number of planes scheduled to be in the air for any given hour of each day. Keeping in mind that some planes depart on one day and arrive on another day. I have attached a sample data set excel file. Example Data Set: FLight ID Scheduled Depart DateTime Scheduled Arrive DateTime 123 07/12/2020 14:15:00 07/13/2020 01:00:00 456 07/12/2020 15:30:00 07/12/2020 20:30:00 789 07/12/2020 14:45:00 07/12/2020 21:15:00 Link to comment Share on other sites More sharing options...
Julie Sebby Posted July 15, 2020 Share Posted July 15, 2020 Are you looking for a suggestion for a visualization type Link to comment Share on other sites More sharing options...
Jason Millett 2 Posted July 15, 2020 Author Share Posted July 15, 2020 Not neseccarily the type of visualization ( I was hoping to use a bar chart or line chart) but how to count the planes in the air for each hour. I can't figure out how to get the correct count for each hour of the day every day. Link to comment Share on other sites More sharing options...
Fabian Duerr Posted July 16, 2020 Share Posted July 16, 2020 You can follow this approach. It's the same question: https://community.spotfire.com/questions/counts-over-time#node-1115426 I have attached the modified excel and dxp file. Here's the result: I hope this is what you was looking for. Let me know if you have further questions. Link to comment Share on other sites More sharing options...
Jason Millett 2 Posted July 16, 2020 Author Share Posted July 16, 2020 Excellent! This is exactly what I needed. I knew I needed a thrid data point but I didn't know what to use. Essentially I have to join to a table with every hour of every day for the date range. Thank you! Link to comment Share on other sites More sharing options...
Fabian Duerr Posted July 16, 2020 Share Posted July 16, 2020 Exactly. Depending on the stepsize (day, hour, minutes) of your merged table you can adjust the resolution. (Also check the details of the calculated column. You have to account that a plane arriving at 7:45 was in air between 7 - 8.) Thanks for the feedback Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now