I have a dataset related to mobile products and I was thinking to build a sanky dashboard using the data but I don't know where to start, as my requirement is lil different than what has been answered already in the forum.
I was referring to Sankey diagram made of dynamically generated polygons but in the attached excel sheet, I have the below fields:
customer - unique customer id
product - product which is available for purchase
quantity in cart - total number of products customer has placed in the cart
purchased - number of products customer purchased, if its 0 - no purchase done
Here, I wanted to show the customer flow, in the below table, user on 07/22 has added 2 iphones, 1 LG, 1 SONY, 2 BLACKBERRY and 5 LENOVO phones to the cart, but in the end - customer bought only 1 Lenovo phone.
I want to show this as attached Sankey diagram.
It will be a great help if anybody can guide me to achieve this.
Thanks in advance.