Forum Discussion

vitoraraujo's avatar
vitoraraujo
Frequent Visitor
9 years ago
Solved

Monthly KPI's

  Hi there.   I want to create a monthly report that shows me some KPI's, from the data pulled from our database about the players.   I have this Table called IAPs (In App Purchases) ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • vitoraraujo's avatar
    vitoraraujo
    9 years ago

    Hi v-qiuyu-msft

    I managed to solve this issue, your inclination was ritgh, the final formula that sucessfully calculates the Cohort KPI is the following:

    buyers per month = CALCULATE(DISTINCTCOUNT(IAPs[player]),ALLEXCEPT(IAPs,IAPs[player date created mensal], IAPs[month cohort]), IAPs[DATECREATED (bins)]>= EARLIER(IAPs[DATECREATED (bins)]))

    Then I just divided buyers per month by the new players that entered that month and obtained the correct answer : 


     

     I used to think that the data should decrease as the month cohort raised, that thought is correct although that's not the proper way to calculate it. The values should decrease as the DATECREATED (the date of the events; i.e. the actual Time, with capital T) passes.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi vitoraraujo,

 

Can you clarify the formula to count buyers each month? I notice you use IAPs[month cohort] >= EARLIER(IAPs[month cohort])), why don't use the [Player date created] or [DATECREATED]?

 

Please share some sample data and desired results for our analysis if possible.

 

Best Regards,
Qiuyun Yu

vitoraraujo's avatar
vitoraraujo
Frequent Visitor
9 years ago

Hi v-qiuyu-msft

I managed to solve this issue, your inclination was ritgh, the final formula that sucessfully calculates the Cohort KPI is the following:

buyers per month = CALCULATE(DISTINCTCOUNT(IAPs[player]),ALLEXCEPT(IAPs,IAPs[player date created mensal], IAPs[month cohort]), IAPs[DATECREATED (bins)]>= EARLIER(IAPs[DATECREATED (bins)]))

Then I just divided buyers per month by the new players that entered that month and obtained the correct answer : 


 

 I used to think that the data should decrease as the month cohort raised, that thought is correct although that's not the proper way to calculate it. The values should decrease as the DATECREATED (the date of the events; i.e. the actual Time, with capital T) passes.