2 Replies Latest reply on Feb 16, 2012 5:52 AM by Richie T

# Average revenue per customer when bundling different products

Hello,

I have been working on this problem for a while now and seem to be getting nowhere. I would really appreciate any help with this!

Attached is a tableau workbook with an example of what I am trying to achieve. I have a list of customers identified by 'Cust Id' in my sample workbook who buys any combination of 3 products -- chairs, stools or tables. Each row in my data is a single transaction of a customer -- it has a total purchase amount and the type of product they purchased and each transaction records would only include one product. I also created a revenue variable for each product in each transaction record and copy over the total revenue amount based on what type of product was purchased.

What I want to be able to do is to plot the average revenue (total revenue/count of distinct customers) if the customers buys one product or a combination of products. The question I am trying to answer -- what is the average revenue if they buy a chair, a chair and stool, chair stool and table etc. and to depict this in a bar chart. I was thinking along the lines of creating a new variable -- 'Bundling' in my sample workbook that would give an indicator of the type of product purchased per customer but not sure if that is the right approach here.

Also attached is a mock up chart of the final result I am looking for.

Thanks in advance for any pointers!!

• ###### 1. Re: Average revenue per customer when bundling different products

I think the picture shows you what you want, though you should check the numbers. I created a window sum of amount, set the compute to ID (on the details shelf), and then (the secret sauce) right clicked the agg(bundle) and deselected Ignore in Table Calculations. If you want to draw a chart around this we will need some extra code to stop the repetition/overlap caused by customer ID on the details shelf.

1 of 1 people found this helpful
• ###### 2. Re: Average revenue per customer when bundling different products

Hi Alex,

Thanks for your response! This is definitely getting there.

The chart mock up I had provided was totally made up numbers. I have uploaded one with the correct calculations. I am looking for the average per customer for each of the bundles. So, in the case of the' chairs, tables and stools' bundle that would be 101177/2=50588.5 since two customers purchased that bundle. The next piece of code would be to get this average number for each bundle and then plot the chart using that.

Thanks once again for your help!

--Richie