Weekly Retention

Anonymous — Sat, 21 May 2022 01:50:19 GMT

Hi, I've implemented monthly retention using https://www.youtube.com/watch?v=vbg4Je1tuis Radacad recommendations and i am having trouble doing it on a weekly basis.

I changed it with weeknum as follows:

first order date (EOW) =

VAR Currentcustomer = entry_events[user_id]

return

CALCULATE(

WEEKNUM(MIN(entry_events[date]),2),

FILTER(

entry_events,

entry_events[user_id]=Currentcustomer

)

Weekly Customer retention % =

VAR CurrentWeekAfter =SELECTEDVALUE('WEEKS AFTER'[Value])

VAR CurrentFirstOrderWeek=SELECTEDVALUE(entry_events[first order date (EOW)])

RETURN

DIVIDE(

CALCULATE(

DISTINCTCOUNT(entry_events[user_id]),

FILTER(

entry_events,

WEEKNUM(entry_events[datetime],2)=WEEKNUM(CurrentFirstOrderWeek,CurrentWeekAfter)

)

DISTINCTCOUNT(entry_events[user_id])

)

WEEKS AFTER =

GENERATESERIES(1,10,1)

It says I have a mistake in second step as i guess :))) how should i correct it? any ideas?

Re: Weekly Retention

v-xiaotang — Tue, 24 May 2022 05:15:00 GMT

Hi Anonymous

Thanks for reaching out to us.

Could you share the sample data and expected result?

usually information below is needed,

(1) a sample file, you can replace raw data with bogus data to protect your privacy.

or provide some sample data that fully covers your issue/question.

(2) give your expected result and its math formula based on the sample you provide.

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.