Hi,
I'm following a tutorial on how to make a RFM analysis on Tableau. I'm new to this so I hope someone can help me.
To find the Recency I have to create a new calculated field and type this in: TODAY() - [Invoice Date]. The problem is that my data sheet is from 2011 so when I use the TODAY () function I get some really big numbers. What do I have to type to use the last day in the data set which is December 11 2011?
Thanks in advance
Hans
@Joachim Bentsen
Hi, in this case you can use something like:
DATEDIFF("day",[Invoice Date],{MAX([Invoice Date])})If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
