Would it be possible to post the packaged workbook (twbx file) so that we can better help you?
Sure. Here's a better explanation of what I'm trying to do:
I want to count the number of people who have made transactions, then didn't make any for 18 months, and then made one within the current month. We classify anyone who hasn't had a transaction in at least 18 months as "Inactive", and if they then make a new transaction we classify them as "Reactivated". We want to count how many reactivations take place each month.
The end goal is to have a chart to show how many people went from "Inactive" to "Reactivated" during each of the last 12 months.
I have a field in the database that lists a person's most recent transaction date, but the crux is figuring out how much time elapsed between the second most recent transaction date and the most current one. If that amount of time is at least 18 months then they were inactive, and if the most recent one was within this month they should be counted as reactivated.
Thanks for the help. I'm just on a demo of Tableau right now and I need to know if this calculation is possible, and I'm still wrapping my head around how to do this sort of thing within the program.
Reactivated.twbx 1.7 MB
Any luck with this?