4 Replies Latest reply on Oct 18, 2013 8:49 AM by P Fro

# How many orders does it take to reach a specified income level

I am trying to create a viz (or a calculation I can use in a viz) whereby I can show the average number of "orders" it takes to reach a specified income level from each customer. In my head, I'm visualizing something similar to Christian's "Tale of 100" viz which shows how many years it took to for a company to hit 50M in sales. My view differs, because I would be looking at individual orders and their associated amounts to determine the number of gifts it took to reach n (let's just say \$1,000) cumulative amount per customer.

For example:

Customer 'A' has 24 total orders with a cumulative amount of \$1,250; at order 19, he reached \$1,000 in total sales. 19 is the number of sales it took to reach \$1,000 for him.

Customer 'B' has 20 total orders but he hit \$1,000 cumulative with his 5th order so his number is 5.

So combined, the average is 12 orders to reach \$1,000.

I could do a lot of data manipulation and custom calculations before getting it into Tableau in order to come up with a "magic number" per customer, but I'm wondering if this is possible with a "normal" (order level) data set.

Any ideas?

(I asked a similar question months ago, but got no responses, so I apologize for repeating myself, but I figured I'd try again just in case)

• ###### 1. Re: How many orders does it take to reach a specified income level

Hi P Fro:

Sorry your question went unanswered.  I would guess that you didn't get a response because no workbook is uploaded.  Create some sample data, plop it into Tableau, and save as a packaged workbook file.  I'd guess you are 90% more likely to receive a quality response if you do this.

See this link for more advice on posting to the Forum: http://community.tableau.com/docs/DOC-5065

By the way, I believe it is definitely possible--almost anything is with Tableau!  I could envision a running_sum of order counts and sales, with one or more calculations used to create your criteria and identify how many orders it took to reach ___ level of sales.

Cheers, and no offense intended at all.

1 of 1 people found this helpful
• ###### 2. Re: How many orders does it take to reach a specified income level

You just made my night. This was wicked fun. Please review the attached and let me know if you have any specific questions. I did not comment much of anything in there so do not hesitate to follow up .

Dan

• ###### 3. Re: How many orders does it take to reach a specified income level

Very nice, Dan!

• ###### 4. Re: How many orders does it take to reach a specified income level

Wow, cool. Didn't even get a chance to reply to Matthew yet, but thank you both for the help! I can't wait to dig into that workbook to see what you have done. Thanks to you both!

Update: Love what you did Dan, thanks for the help!