1

I am trying to make a retention cohorts report in Tableau which looks like the one below: Target

I have a DataSet which does precisely this calculation however the format is a little different and based on that I am able to achieve the following graph:Halfway through

I want to figure out if there is a way to calculate dates rather than " x months since date" for X-AXIS so that my graphs look like the one above.

Attached is the workbook for reference. TABLEAU WORKBOOK

Sam M
  • 4,136
  • 4
  • 29
  • 42
Samyak Jain
  • 117
  • 2
  • 11

1 Answers1

1

Create a calculated field that will add the cohort date and the months columns.

dateadd("month", int([month]), [cohort_month])

Replace the months pill in your column shelf with this new calculated field. If it defaults to Continous when you place it on the column shelf, right-click and change it to discrete. This will give you an x-axis that is a date value. On your Marks shelf, remove Measure Name from the color so that the cohort months determine the color of each line.

I tried it with the twbx from your question and this approach worked.

Sam M
  • 4,136
  • 4
  • 29
  • 42