Cohort for two Formulas

[#1]

Hi All,

I need to do a Cohort Analysis likewise the one which was done by sunindia‌ attached at the bottom. This time I need to show the New Revenue and Churn. I need to show the Cust Internal ID which added new revenue and the IDs which churned. In order for one to find the new revenue and churn in the Excel sheet attached just remove the - hyphen from the filters of the columns and one will view the data.

Please provide insights.

Thanks,

[sunny_talwar]

I will have a look Arsalan and will get back to you

[#3]

Thanks Sunny for your help, your always there thanks a lot......

[sunny_talwar · Accepted solution]

Are we there now?

Quantity Expressions:

1) =Count(DISTINCT {<[New Revenue] = {'>0'}>} [Cust Internal ID])

2) =Count(DISTINCT {<Churn= {'>0'}>} [Cust Internal ID])

[#5]

Thanks Sunny for all your help in tackling these issues. Problems have been resolved.

[sunny_talwar]

Great, I am glad we finally got it to work now