8 Replies Latest reply on Mar 12, 2019 3:24 AM by 재현 이

# How to calculate repurchase rate for same item?

I asked something similar before and members were very helpful. i am looking for something different now:

i am attaching a workbook where i have a list of customers who purchased an item. same customers might purchase the same item multiple times. what i like to do is flag the initial purchase and look at repurchase rate within timeframe: 30 days of initial purchase, day 31 to day 60 from initial purchase, day 61 to day 90 from initial purchase and rate over 90 days within initial purchase:i want to use the time frame as filter.

below is my initial view in tableau. for example customer A initial purchase of the car is 12/1/2017. Customer A repurchased the car 5 times after his initial purchase. his purchase rate within 30 days is 100%, his purchase rate day 31 to fay 60 is 0 as he didn't purchase car, his purchase rate day 61 to day 90 is 100% and his purchase rate over 90 days is also 100%. so this customer repurchase rate for the car overall is 100% as he purchased it multiple times after his initial purchase.

i like to have a view that shows the item as main field, countdistinct initial purchases, countdistinct of purchases after the initial purchase, and repurchase rate and use time frame as filter :  see below for the Car: car was bough twice by customer A and B so initial purchase is 2, both customers A and B repurchased the car so repurchases is 2 as well, and repurchase rate is 100%

any help is greatly appreciated.

Tony

• ###### 1. Re: How to calculate repurchase rate for same item?

Is this the output you are expecting?

If yes, then here are the calculated fields that I have created to achieve the above result.

Purchase Rate < 30 Days:

IF {FIXED [Customer],[Item]:COUNT(IF [Date]>[First Purchase Date] AND [Date]<=DATEADD("day",30,[First Purchase Date]) THEN [Date] END)}>0 THEN

1

ELSE

0

END

Purchase Rate 31-60 Days:

IF {FIXED [Customer],[Item]:COUNT(IF [Date]>DATEADD("day",30,[First Purchase Date]) AND [Date]<=DATEADD("day",60,[First Purchase Date]) THEN [Date] END)}>0 THEN

1

ELSE

0

END

Purchase Rate 61-90 Days:

IF {FIXED [Customer],[Item]:COUNT(IF [Date]>DATEADD("day",60,[First Purchase Date]) AND [Date]<=DATEADD("day",90,[First Purchase Date]) THEN [Date] END)}>0 THEN

1

ELSE

0

END

Purchase Rate >90 Days:

IF {FIXED [Customer],[Item]:COUNT(IF [Date]>DATEADD("day",90,[First Purchase Date]) THEN [Date] END)}>0 THEN

1

ELSE

0

END

Overall Purchase Rate:

IF {FIXED [Customer],[Item]:COUNT([Date])}>1 THEN

1

ELSE

0

END

Even if it's not the expected answer, hope it will at least help you get to your desired results. The updated workbook is attached.

1 of 1 people found this helpful
• ###### 2. Re: How to calculate repurchase rate for same item?

Hari, this is great, i couldn't download the workbook as i am using an older version.

what about if i want to show the item as main field without showing the customer detail?

Thanks again

• ###### 3. Re: How to calculate repurchase rate for same item?

If you do not want to show the customer detail, then you may need to modify the formulas.

1 of 1 people found this helpful
• ###### 4. Re: How to calculate repurchase rate for same item?

I am struggling to remove the customer detail and show only repurchase rate by items. any idea from your side on how to make the changes?

Thanks for the feedback.

Tony

• ###### 5. Re: How to calculate repurchase rate for same item?

You may need to take averages then.

1 of 1 people found this helpful
• ###### 6. Re: How to calculate repurchase rate for same item?

Hari, this is works wonders! Thanks for the help.

Tony

• ###### 7. Re: How to calculate repurchase rate for same item?

You are welcome.

• ###### 8. Re: How to calculate repurchase rate for same item?

i can not get it how average values comes from?

what is it mean 100% purchase rate then ?