0 Replies Latest reply on Oct 26, 2018 2:23 PM by Rakshith Basavaraj

    Dynamic long polygon sankey diagram

    Rakshith Basavaraj

      Hello Guys,

       

      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

      date

      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.

      005cccc0-1cb8-4628-9502-63f989055d35LENOVO7/22/201851
      005cccc0-1cb8-4628-9502-63f989055d35BLACKBERRY7/22/201820
      005cccc0-1cb8-4628-9502-63f989055d35SONY7/22/201810
      005cccc0-1cb8-4628-9502-63f989055d35LG7/22/201810
      005cccc0-1cb8-4628-9502-63f989055d35IPHONE7/22/201820

       

      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.