Calculate Daily average last 30 days, last 7 days

[Anonymous]

Hi All,

I have the a data set that looks like this, which contain roughly 200k rows and I'm trying to calculate the following:

We receive daily new member (and they are represented by member_id) and I'm trying to calculate the average of member for each bullet point mentioned.

• Daily average last 30 days of members_ID
• Weekly average last 7 days of members_ID
• Monthly average last 6 months of members_ID

Member_ID	Registration_Date	Zip_Code	Age
1010XHJT	4/12/2020	85743	25
1011HRFO	4/12/2020	72209	32
1213WEKO	4/13/2020	74104	45
1456LKPW	4/13/2020	60140	62
6548ZGTU	4/2/2020	65248	72
15486UTXA	4/6/2020	65245	33

Any helps would be appreciated

[lbendlin]

Average of what? Age? Number of visits?

[Anonymous]

@lbendlin I'm trying to calculate the average of Member_ID(which are new people that are registraring evey day)

[lbendlin]

we're still missing one piece of information. Average by what?  Sliding window of 7/30/90 days by each day in your calendar, by each monday on your calendar, or something else? Basically - what is the end date for your sliding windows?