How to calculate Monthly aggregates from daily data

Question

Post reply

How to calculate Monthly aggregates from daily data

December 20, 2021 at 11:46 am

This was removed by the editor as SPAM

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply

asita SSCarpal Tunnel Points: 4144 More actions · Answer 1

Hi Jeff Good Morning,

Any advise please

Thank you,

asiti

asita SSCarpal Tunnel Points: 4144 More actions · Answer 2

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: 1004321 More actions · Answer 3

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)