5 Replies Latest reply on Apr 23, 2013 5:25 AM by Alex Kerin

    Window_sum at different levels of detail?

    Hannah Moore

      Hi have a data set that looks like this:

       

      DateGroupTime of OccurrenceLengthTotal Hours Worked on that DayReasonIndividulal
      4/1/13A8:00am58DelaySmith
      4/1/13A9:00am158WaitSmith
      4/1/13A11:00am510DelayJones
      4/1/13A1:00pm4010DelayJones
      4/1/13A1:15pm2010WaitJones
      4/1/13A8:30am59WaitJacobsen
      4/1/13B9:00am258WaitBlue

       

      Essentially, I want to be able to sum the length column and divide by the total hours worked that day for each group.

       

      So, for group A the I am trying to find a table calc that will sum to 27 (8 hrs for Smith, 10 hrs for Jones and 9 hours forJacobsen) for 4/1/13 (that I would then also want to roll up by month, year, etc...  I haven't been able to figure this out.  Does anyone know how to make this work?

       

      Thank you!

      Hannah