Put a Date field on the filter shelf and set the date range to 15 days.
Put the Customer field on the row shelf.
Put the Number of Records on the Text shelf
Create a calculation with this formula:
Put this on the filter shelf and set it to true.
Anyone who bought something everyday for the 15 day date period will be visible.
THank a lot for the answer Shawn,
let me describe the problem more detail, the customer wants those customers who made purchases in consecutie 15 days in a given period, lets say the period is one year they want to scan 1-15 january and then 2-16 of january 3-17 of january till 16-31 december and would like identify those customers who made purchases in a single store everyday in any of those 15 days period.
is there any way to achieve this wi Tableau?
thanks a lot for the help
It would have to be some sort of Running_Sum on each individual customer with a trigger so it resets to zero if it encounters a NULL value. You'd have to post a packaged workbook with some sample data for anyone to figure out exactly how to do this. But warning, it also sounds like it will be very slow.