Hi Jason - I believe this solves it for you. You need to include a couple LOD calculations and then add your order date filter to context - lastly making that filter a range of dates to select from.
Here's the recency calc after those LOD formulas are added. Hope this helps!
recent_orders.twbx 2.3 MB
Thanks for this. This works for the Superstore data as expected -- when you look at the underlying data (View Data...), the max date is always whatever is set as the end date in the date range filter and so it calculates recency correctly.
However, when I try to copy over the same methodology over to my proprietary dataset that is in a similar format to the workbook, when I check the underlying data of the view, the Last Customer's Order as well as the Max Date both ignore the date range filter altogether.
Any ideas what would cause the two LOD calculated fields (Last Order, Max Date) to not obey the date range filter?
1 of 1 people found this helpful
Have you added your date filter to context?
Happy New Year!
Yes, I realized I had to add to context and it fixed the issue!
Thanks a bunch,