4 Replies Latest reply on Jul 30, 2018 12:08 AM by tanja.kemppainen

    summarizing order data to visualization

    tanja.kemppainen

      Hi,

       

      I have simple data for orders. Each customer has as many rows as they have orders.

       

      I want to find out how many customer bay some product combinations and to go even further find out how many purchased products in specific order.

       

      Example of my data:

       

      customer

      product

      shipping_date

      price

      1

      boat

      2.6.2017

      50

      1

      bike

      7.8.2017

      60

      1

      car

      8.9.2017

      75

      2

      car

      12.1.2017

      80

      2

      boat

      18.9.2017

      60

      3

      boat

      25.6.2018

      55

      4

      car

      11.1.2017

      45

      4

      boat

      30.4.2017

      35

      4

      car

      12.6.2017

      60

      4

      bike

      25.9.2017

      80

       

      Visualization:

       

                                   amount of customer

      car&bike                         2

      car & boat                       3

      bike before car               1