Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cohort Analysis Help

I have been struggling to determine how to calculate the denominator values in the attached examples. Getting the Cohort data and Numerators are easy but just cant figure out the denominator to get t...
"DAX"
AnthonyGenovese's avatar
AnthonyGenovese
Resolver III
3 years ago

Just provide an example using the table feature in the post reply

Anonymous's avatar
Anonymous
Not applicable
3 years ago
132372921282523232215
3991359370686159605549
393184138120989183868066
2961421291111009187778076
1771089483807070646562
26313212312310810092908590
400271237226220217190196181173
779558503477448423421363296259
628344264169102450000

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This is an example of  the data that I am using and represents the numerator part of the equation. I am not that familiar with the OFFSET function in Excel and having a nested OFFSET inside an offset is thowing me off on how the denominator is being calculated. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

       

      132132132132132132132132132132132
      399399399399399399399399399399399
      393393393393393393393393393393393
      296296296296296296296296296296296
      177177177177177177177177177177177
      263263263263263263263263263263263
      400400400400400400400400400400400
      779779779779779779779695624546466
      62851739827915478162233311391446
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        This is the expected outcome for the denominator