-
1. Re: How to calculate repurchase rate for same item?
Hari Ankem Oct 30, 2018 1:51 PM (in response to Tony Fahd)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.
-
Repurchase Rate.twbx 20.7 KB
-
-
2. Re: How to calculate repurchase rate for same item?
Tony Fahd Oct 30, 2018 2:02 PM (in response to Hari Ankem)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?
Hari Ankem Oct 30, 2018 2:17 PM (in response to Tony Fahd)If you do not want to show the customer detail, then you may need to modify the formulas.
-
Repurchase Rate_v10.2.twbx 20.7 KB
-
-
4. Re: How to calculate repurchase rate for same item?
Tony Fahd Oct 30, 2018 2:14 PM (in response to Hari Ankem)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?
Hari Ankem Oct 30, 2018 3:22 PM (in response to Tony Fahd)-
Repurchase Rate_v10.2.twbx 38.5 KB
-
-
6. Re: How to calculate repurchase rate for same item?
Tony Fahd Oct 31, 2018 7:47 AM (in response to Hari Ankem)Hari, this is works wonders! Thanks for the help.
Tony
-
7. Re: How to calculate repurchase rate for same item?
Hari Ankem Oct 31, 2018 9:11 AM (in response to Tony Fahd)You are welcome.