topic Percentage Calculation in Cohort Analysis in App Development

Percentage Calculation in Cohort Analysis

Pericator — Tue, 25 Jun 2019 08:59:33 GMT

Hello,

I built a Cohort Analysis Table like the image below. But I cant figure out, how I am able to calculate the percentage values of each column and row in Comparison to the first value in the row.

E.G.: In the 'Juni-2017' column I want the Percentage difference between 2215 and 2159 which is roughly 97%. In the row below I want 100% because 81 is 100% of itself.

Thanks in Advance

Re: Percentage Calculation in Cohort Analysis

sunny_talwar — Tue, 25 Jun 2019 12:02:02 GMT

What is your expression for Member here?

Re: Percentage Calculation in Cohort Analysis

Pericator — Tue, 25 Jun 2019 12:05:58 GMT

Count({<isMember = {1}>}DEALER_ID)

Re: Percentage Calculation in Cohort Analysis

sunny_talwar — Tue, 25 Jun 2019 12:09:43 GMT

May be this

Alt( Count({<isMember = {1}>}DEALER_ID)/Before(Count({<isMember = {1}>}DEALER_ID)) , 1)

Re: Percentage Calculation in Cohort Analysis

Pericator — Tue, 25 Jun 2019 12:17:33 GMT

alt ( ...

Before(Count({<isMember = {1}>}DEALER_ID))

)

just returns the value, one column before and not the first in the row.

Re: Percentage Calculation in Cohort Analysis

Pericator — Tue, 25 Jun 2019 12:39:25 GMT

I got it to work with :

left([Member], 1000) / count(distinct total <YEARMONTH>{<isMember={1}>}DEALER_ID)

YEARMONTH is the upper Dimension. The 1000 is just way overgrowth to make sure, it takes all digits in the field.

Sadly the same doesnt work for my second Pivot, although its exactly the same just with Fees instead of Members. E:G.:

Fee is: Sum({isMember={1}}DBD_LISTING_FEES)

and % therefore should be: left([Listing Fee], 1000) / Sum(total <YEARMONTH>{isMember={1}}DBD_LISTING_FEES)

But this doesnt work, dont know why though.