0 Replies Latest reply: Feb 11, 2013 1:24 PM by Robyn Talley RSS

    Count by First Date

      If I am counting presentations given per week.  But my table has some presentations with two date values in error, how do I get the count to only show in one week. Preferably the earliest date?  Below is a sample table.  SOme of the counts each week are overstated because my data might have two week dates listed for a presentation.  Thanks!

       

      count

      ({$<PresentationType = {'*Life*','*Senior*'}-{'*Paid Up*','*Select*'}, HouseholdMember = {'Primary'}>} Distinct PresentationID)

       

       

       

      Week   Presentation Given

       

       

      07/05/2012     1,898

       

       

      07/12/2012     1,959

       

       

      07/19/2012     2,063

       

       

      07/26/2012     1,929

       

       

      08/02/2012     2,033

       

       

      08/09/2012     1,943

       

       

      08/16/2012     1,933

       

       

      08/23/2012     2,040

       

       

      08/30/2012     1,938

       

       

      09/06/2012     1,712

       

       

      09/13/2012     1,851

       

       

      09/20/2012     1,968

       

       

      09/27/2012     2,020

       

       

      10/04/2012     1,923

       

       

      10/11/2012     1,773

       

       

      10/18/2012     1,928

       

       

      Presentation
        Given
      07/05/20121,898
      07/12/20121,959
      07/19/20122,063
      07/26/20121,929
      08/02/20122,033
      08/09/20121,943
      08/16/20121,933
      08/23/20122,040
      08/30/20121,938
      09/06/20121,712
      09/13/20121,851
      09/20/20121,968
      09/27/20122,020
      10/04/20121,923
      10/11/20121,773
      10/18/20121,928