-
1. Re: Calculating the count of purchases made by a customer on the first purchase date
Andrew Watson Nov 30, 2016 2:15 PM (in response to Megha Chhabra)Best to do this step by step so you understand what's happening.
First you want to isolate the first day of purchase for each customer. I'm going to make up field names but it should be obvious. {FIXED [Customer]:MIN([OrderDate])}
Next return the products bought on that day:
IF [OrderDate] = {FIXED [Customer]:MIN([OrderDate])} THEN [Product] END
You're then able to to a distinct count on that field.
-
2. Re: Calculating the count of purchases made by a customer on the first purchase date
Megha Chhabra Nov 30, 2016 2:31 PM (in response to Andrew Watson)Hi Andrew,
This is still not giving me the count of product bought on first date.
I created one calculated field as first date: {FIXED [Customer]:MIN([OrderDate])}
and second as IF [OrderDate] = {FIXED [Customer]:MIN([OrderDate])} THEN [Product] END
I dragged one into the columns and added the other as a count field in row. It is still not giving me the correct data.
Kindly help
-
3. Re: Calculating the count of purchases made by a customer on the first purchase date
Nachiket Dekhane Nov 30, 2016 2:41 PM (in response to Megha Chhabra)Hi Megha.
Can you post a packaged workbook? It's hard to see where the problem lies without looking at the data.
Thanks,
Nachiket
-
4. Re: Calculating the count of purchases made by a customer on the first purchase date
Megha Chhabra Nov 30, 2016 2:58 PM (in response to Nachiket Dekhane)Thank you so much guys.
It worked !
-
5. Re: Calculating the count of purchases made by a customer on the first purchase date
Megha Chhabra Nov 30, 2016 4:08 PM (in response to Andrew Watson)Hi ,
I was able to compute the count on first day, but I having another issue. Please share your thoughts on this.
If I put the filter for month May, it still shows me my original first purchase date ( i.e. Jan).
What to do if i need to see the data of first purchase data for a particular month ?
Thanks !
-
6. Re: Calculating the count of purchases made by a customer on the first purchase date
sudhakar reddy Nov 30, 2016 9:46 PM (in response to Megha Chhabra)Hello Megha,
I've recreated it without LOD's.
Let me know if it helps.
Regards,
Sudhakar Reddy
-
firstpurchase.twbx 1.1 MB
-
-
7. Re: Calculating the count of purchases made by a customer on the first purchase date
Andrew Watson Nov 30, 2016 11:55 PM (in response to Megha Chhabra)Add your month filter to context (click the drop down arrow on the month pill on the filters shelf to do this)
-
8. Re: Calculating the count of purchases made by a customer on the first purchase date
Megha Chhabra Dec 1, 2016 8:37 AM (in response to sudhakar reddy)Yes,please share your solution
-
9. Re: Calculating the count of purchases made by a customer on the first purchase date
Megha Chhabra Dec 1, 2016 10:55 AM (in response to Andrew Watson)Thanks !
It worked