2 Replies Latest reply on Jul 5, 2016 11:39 AM by Ivan Young

# % of buyers of a same seller

Hello!

I have two columns: seller and buyer. I want to have the % of buyers that buys on a same seller.

For example:

11112222
11112222
44444433
55558888
55558888
44449999
77779239

Of this way we have two buyers that buy on a same seller: 1111 and 5555 (not 4444 because buy on different sellers). So the 50% of buyers buy on a same seller (this is I want to obtain in a pie chart)

It is possible? Could you help me to obtain this data?

Thanks!!

Regards

• ###### 1. Re: % of buyers of a same seller

I think I can get you at least part of the way there.

I created two calculated fields:

1.  Duplicate Seller

COUNT([Seller]) - COUNTD([Seller])

2.  Non-Duplicate Sellers

COUNT([BUYER]) - [Duplicate Seller]

I then selected "Pie" from the Marks card and placed one of the calculated fields we created in "Color" and then Buyer in "Details"

I hope this helps!

Larry

• ###### 2. Re: % of buyers of a same seller

Hi Mauro,

I'm not really clear on what you are expecting, looking at your data I see 75% of your buyers buying from the same seller, how do you end up with 50%?   You might be able to solve this easily with an LOD expression.  Can you explain what you expect buyer 7777 to fall under, it looks like same seller to me?

Regards,
Ivan