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
