7 Replies Latest reply on Nov 7, 2018 8:26 AM by Seth Nelson

    Calculate Number of Days Elapsed Since Start of Events

    John Tribble

      I am trying to create a calculated field that marks the number of days elapsed since the start of various events.  The goal is to plot events that take place at different times each year by the day of the event (weekends included).  For example, we have seasonal training windows, such as winter training, spring training, etc.  We offer lunch and learns where attendence is recorded. The training windows are not in the exact date window each year.  It is the goal of this project to show how many people attend the lunch and learns on day 1 of each training window each year, day 2, day 3, etc.   I have a table below illustrating what I have and what I want to get from it.  I havent tried anything yet, but I know I want to use the 'Training Window' field and the 'Date' field to calculate the 'Days Since Start of Window' field.Any help would be much appreciated.

       

      Current Table

      Training WindowDateNo. of Attendees
      Winter12/1/201712
      Winter12/4/201721
      Winter12/5/201714
      Winter12/6/201716
      Winter12/7/201732
      Winter12/8/201714
      Winter11/28/201613
      Winter11/29/201625
      Winter11/30/201625
      Winter12/1/201620
      Winter12/2/201613
      Winter12/5/201614
      Spring4/1/201710
      Spring4/2/201714
      Spring4/3/201732
      Spring4/4/201731
      Spring5/1/201618
      Spring5/2/201617
      Spring5/3/201630
      Spring5/4/201640

       

      Table with additional field I would like calculated:

      Training WindowDateNo. of Attendees
      Days Since Start of Window
      Winter12/1/2017121
      Winter12/4/2017214
      Winter12/5/2017145
      Winter12/6/2017166
      Winter12/7/2017327
      Winter12/8/2017148
      Winter11/28/2016131
      Winter11/29/2016252
      Winter11/30/2016253
      Winter12/1/2016204
      Winter12/2/2016135
      Winter12/5/2016148
      Spring4/10/2017101
      Spring4/11/2017142
      Spring4/12/2017323
      Spring4/13/2017314
      Spring5/9/2016181
      Spring5/10/2016172
      Spring5/11/2016303
      Spring5/12/2016404