0 Replies Latest reply on Aug 12, 2013 1:28 AM by Yuriy Gavrilov

    Calculation of weekly repeat sales by distinct customer and location?

    Yuriy Gavrilov

      Hi,

       

      I have a kind of table below as a data source. The total count of Sites is 85, and overal count of rows is 219 000 000 for 1 year data.

      The goal is to calculate repeat sales by week. Need to visualise sum of sales and count of distinct client whith come back to the same site on next week. In my example this is client 1 whith come back 2 times to site A. In additional will be great to calculate % of reapet sales client to all clients by site and week. Sites and weeks will be as a parameters with multiselection optioon.

       

      Site ID Customer IDweekSales
      A11100
      A12200
      A13300
      B21100
      B31100
      B42100
      B52200
      B63100
      C71200
      C82300
      C93200
      A101100
      A112200
      A123300

       

      I imagine that the results table could be something like this:

      Week123
      Site IDrepeat sales (Client)repeat sales (Sales Amount)% to total sales amountrepeat sales (Client)repeat sales (Sales Amount)% to total sales amountrepeat sales (Client)repeat sales (Sales Amount)% to total sales amount
      A110050%120050%130050%
      B000000000
      C000000000

       

      Could somebody suggest a solution for this case?

      Thanks for any help

      Yura

       

      Yura