Hello I was wondering if anyone had any suggestions as to how I could track a customer ID#, date, and product type, to put together a list of which customer's are returning year after year, and how many items they are purchasing? I have the data captured but do not know how to display this visually... Thanks for the help!
Solved! Go to Solution.
Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue? Do mask sensitive data before posting.
|MAIL #||Purchase Date||Product Type|
Thank you for the responses. Above is the data that I would like to have analyzed...I am hoping to get results that look something like this...
|Year||Total Customers by Mail #||Number of Products Purchased||New Customers||Returning Customers|
I would also be interested in Identifying specific customers by Mail# that held a pass in one given year, did not return the following year, but still returned at a later date.
Hopefully that makes sense. Please let me know if you have any futher questions!
Thank you I think that should work, however I am getting an error with computing the date. I typed
Date = CALENDAR(MIN(Data[Purchase Date]),MAX(Data[Purchase Date]))
and I am getting an error of
"A table of multiple values was supplied where a single value was expected."
Any idea what is causing this error?
Would it also be possible to calculate the average number of tickets sold to the customers? As a measure it looks like I can not just have it average in a visualization like I was hoping. Would it also be possible to determine something like "55 customers purchased between 0-2 tickets in 2015", "65 Customers purchased between 2-4 Tickets in 2015"?
Thanks so much for the help.