Draw continuous trend line for separate calculated measures

Question

Sheet 1: I've created 5 separate calculated measure fields to show 1+, 2+, 3+, 4+ and 5+ months based on the Number of Days data field. This is the undesired output for these fields

Sheet 2: Desired Output for Sheet 1

I want to create a trend line for the number of Distinct ID's falling in each month+ field. I've taken the output numbers and constructed Sheet 2 to show the Desired Output. How do I make this happen for Sheet 1 based on the calculated fields and other measures only? Is there any other way of doing this? Thanks

Tableau 9.3 Workbook-

Packaged Workbook Download

Answer 1

You can set it up like this and you will get your line.

You could also get something like this to have it more detailled:

The [date] field has this formula : DATEADD('day', [Days], NOW()) and use a table calculation for the count like this

If you don't want to have it based on NOW() you could just use a date parameter to set a dynamic anchor.