Forum Discussion

Bharani308's avatar
Bharani308
Frequent Visitor
6 years ago

Cohort Analysis Help

 

@Follow the link for Files

https://drive.google.com/drive/folders/1zRC1FBn_3lUNSY5TBJueXdlfrQFnypQK

My Cohort Table:

Cohort Table

Actual Applications and Deposits

Actual Apps and Deposits

I would like to show a cohort table using the above data 

How many students applied in a specific month and out of which how many deposits happened in subsequent months.

with below approach, it is giving me the number of applications sent by students in a specific month but it's not giving me a number of deposits on the same month

Example:

In the month of July 2019, 96 applications out of which 3 deposits made in July 2019, 8 deps made on Aug2019, 5 in Sep2019, 4 in Oct2019, and 1 in December 2019.

My cohort table is showing deposits for all the months except July.

Can someone please help me with the same?

amitchandak 

Greg_Deckler

v-frfei-msft 

MFelix 

PaulDBrown 

Mariusz 

Anonymous I tried following your approach posted here

 

3 Replies