5 Replies Latest reply on Feb 7, 2017 9:59 AM by Yuriy Fal

    Cohort Summaries by Retention Month

    bonnie.caruso

      I've seen (and used) a few posts about creating cohort analysis workbooks in Tableau and have been successful in pulling together the attached based on instructions found here in the community.  I'm trying to take this one step further by calculating an average and weighted average for each retention month, and would appreciate a bit of help from the more advanced users here.  I've attached a workbook with an extract of sample data to support a cohort analysis similar to one found here.  Also attached is an excel spreadsheet that contains an export of the data in Tableau, with rows added to calculate an average and weighted average by retention month.  The latter uses sumproduct and sumif formulas to only include those values where months exist.  I would greatly appreciate any suggestions on how to do what I've done in Excel within the Tableau workbook.