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

    % of buyers of a same seller

    Mauro Luna

      Hello!

       

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

      For example:

      Buyer Seller
      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
          Larry Newdorf

          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
            Ivan Young

            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