Lead Report with multiple dates
Hi Team,
I'm kind of stuck in designing a report and need your help. We have Leads Datatable in Zoho Reports in which we have two custom fields of type Date as
1. First Meeting
2. Second Meeting
Now I need to build a report that shows me number of meetings occurred in particular week/month/quarter
Forexample I have following 3 records:
Lead A
1st meeting: 15/May/2013
2nd meeting: 15/July/2013
Lead B
1st meeting: 15/June/2013
2nd meeting: 15/July/2013
Lead C
1st meeting: 15/July/2013
2nd meeting: NULL
On Above data, I need some report (chart or table) to show something like below
Month Meeting Count
May 2013 1
June 2013 1
July 2013 3
How can I acheive that ?
Thanks,
Hasan