1 Reply Latest reply: Apr 15, 2014 3:46 PM by Michael Solomovich RSS

    Count visit with Asynchronous Date in same table

      Hi,

       

      I've a fact table with this information :

       

      DateVisit     IDClient     DateTransformCustomer

      2014/03/01     1               2014/04/01

      2014/05/01     1               2014/04/01

      2014/02/01     2               2014/02/18

      2014/05/01     2               2014/02/18

       

      The date transform is the date when a potential customer become a real customer

      I want to see the number of visit by month and the number of customer transformed

       

      MonthVisite          countVisit          CountTransformedCustomer

      01 - Jan               0                         0

      02 - Feb               1                        1

      03 - March            1                        0

      04 - April               0                       1                

      05 - May               2                       0

       

      Thank you in advance