Unique Customers count that bought multiple items at a site
Okay, banging my head and it hurts. While the actual data is patient centric around different codes styles of Veterans Administration will ask it in sales terms.
If you have a data base with sales in Guns, Bows, Fishing Rods, and Ammo each a model attribute. And you have a list of stores that sell these items another model attribute.
Understand how to get the total of sales in each category for each facility.
I want to know how many unique customers (Number of Customers not who) I have at each facility that made a purchase of ANY one of the items but if they bought multiple only count them once.
Thanks in advance for the help!
2 replies
-
Quick clarification. You say guns, bows, ammo etc are attributes. Is that correct or are they members of a product attribute, like say product category?
-
Hi Irad,
I'll make some assumptions about what you want to do and you can correct. I've just built something similar using our Bike Store database. I have sales transaction data by Channel (store, online, distributor) coming from SQL Server. I've built a Pyramid Model against it. In the Data Model tab in the Model module, I selected Columns. Within the Sales Data, I have a field called Customer Key which indicates on the transaction record which customer purchased. For the Customer Key column in the Data Model, I set Measure to Distinct Count.
After running the model, when I bring up a Discover, in the Measures tab there is a measure for Customer Key. I then created a Grid Matrix and used Channel as the Row and then selected Customer Key from Measures. What I got was a count of unique Customer Keys for each Channel. I went back into the data and executed a quick SQL statement to ensure the counts were correct.
You should be able to do the same. If you need help, please reach out to Alex Braylyan or Elaine Charboneau at the VA. If you can't reach them, I'm always happy to assist further.