2 Replies Latest reply on Aug 10, 2017 4:37 AM by Levan Uridia

    can anyone help to make a chart from window calculation

    Levan Uridia

      Hi

       

      I have an airplane flights data which is similar to the one here:

       

      Plane ID     Depatrure/Arrival          DATETIME

      P1                     D                          1/1/2009 12:00:00 PM

      P3                     D                          1/1/2009 12:30:00 PM

      P1                     A                          1/1/2009 2:00:00 PM

      P2                     D                          1/1/2009 3:00:00 PM

      P2                     A                          1/1/2009 6:00:00 PM

      P3                     A                          1/1/2009 1:30:00 PM

       

       

      I want to calculate how many planes were in air at a specific time (for example at 1/1/2009 13:00:00 PM)

      I manage to do this by window_calculations using LOOKUP but then I can not use the number generated by Window_Sum for creating bar chart or any other chart

      I am not allowed to modify table or to make any blending/joins.

       

      Can anyone help with this?

      The worksheet is attached.