How to calculate Monthly aggregates from daily data

• asita

  SSCarpal Tunnel

  Points: 4144

  More actions

  October 13, 2021 at 5:36 am

  #3940025

  Any Advise? please

   

  Week NewMembers FUMembersCounts EUMembersCount

  Oct-03-2021 To Oct-09-2021 0 0 0

  Sep-26-2021 To Oct-02-2021 0 0 0

  Sep-19-2021 To Sep-25-2021 0 0 0

  Sep-12-2021 To Sep-18-2021 0 0 0

  Sep-05-2021 To Sep-11-2021 0 0 0

  Aug-30-2021 To Sep-04-2021 5 3 2

  ...

  ....

  goes to min(Filedate) week

   

  Thanks

  asiti

   

   

• Jeff Moden

  SSC Guru

  Points: 1004646

  More actions

  December 20, 2021 at 1:28 pm

  #3965511

  asita wrote:

  Any Advise? please

  Week NewMembers FUMembersCounts EUMembersCount Oct-03-2021 To Oct-09-2021 0 0 0 Sep-26-2021 To Oct-02-2021 0 0 0 Sep-19-2021 To Sep-25-2021 0 0 0 Sep-12-2021 To Sep-18-2021 0 0 0 Sep-05-2021 To Sep-11-2021 0 0 0 Aug-30-2021 To Sep-04-2021 5 3 2

  ...

  ....

  goes to min(Filedate) week

  Thanks

  asiti

  Apologies.  I lost track of this thread.  Do you still need help with this?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)