7 Replies Latest reply on Jul 6, 2017 6:22 AM by Zhouyi Zhang

# New customer orders vs returning customer orders

Hi All,

I'm new to Tableau.

I want to calculate the: New customer orders vs returning customer orders.  So i want a PIE, telling me what percentage is new and what percentage is returning customer.

I got 9 ip adresses. Out of the 9 ip adresses only 5 customers bought something.

As you can see i got 5 customers that are saying "Aankoop definitief YES'     (Aankoop definitief  means 'Is the product sold?':Yes or No?")

So only 5 bought something and the other 4 customers just viewed the website and left without buying, so those arent customers but only website viewers.

And out of the 5 customers, 3 of them are returning because they bought more than 1 product, as you can see they got duplicate Ip_adresses.

And the other 2 customers with Ip_adress  '128.201.246.18'   &   '203.184.194.176' are new customers because they only bought 1 product as you can see, and their ipadresses only show-up 1time and arent duplicate.

(Blue are the customers and white are just viewers that came on the website)

So can anyone please give me a calculation that says:

" Every customer that ordered more than 2 products is a, returning customer with 'Yes as 'aankoop definitief' "

" And every customer that ordered 1 product is a new customer with  'Yes as 'aankoop definitief' "

Regards,

Jagjit Singh

• ###### 1. Re: New customer orders vs returning customer orders

could you share any sample data or workbook?

1 of 1 people found this helpful
• ###### 2. Re: New customer orders vs returning customer orders

Hi Amit,

Thank you so much for your quick response.

I included my workbook with all the data.

I really hope u can help me out.

I really appreciate this.

Beste Regards,

Jagjit Singh

• ###### 3. Re: New customer orders vs returning customer orders

Hi, Jagjit

Workbook attached with 10.2 for your reference.

Hope this could help

ZZ

1 of 1 people found this helpful
• ###### 4. Re: New customer orders vs returning customer orders

Hi Zhouyi Zhang,

Thank you so much for your effort!

This is exactly what i needed.

The only thing i chanegd is that the ip-adresses you included needs to be the other way around. So on the pie the returning customers are the New customers. And the New customers are the returning customers. (See screenshot)

But everything is perfect so thanks!

One thing i wanted to be different is to show the percentages of returning customers and new customers on top of the pie.

i Tried it but unfortunately it didnt work can you please try for me, to show it on top of the pie.

I included the workbook with the changes

Thankyou so much!

Kind regards,

Jagjit Singh

• ###### 5. Re: New customer orders vs returning customer orders

Hi, Jagjit

Glad it works for you and sorry about the issue of new and return customers.

to your question, please find my updated workbook, and below is a sample result.

Please let me know if you have further question.

ZZ

1 of 1 people found this helpful
• ###### 6. Re: New customer orders vs returning customer orders

Sir,

Thank you so much this was exactly what i needed.

Really appreciate your time and effort.

Regards,

Jagjit Singh

• ###### 7. Re: New customer orders vs returning customer orders

No worries, glad it works for you.

ZZ

1 of 1 people found this helpful