Calculation dataset summarised by date

[vratnayaka]

Brain Freeze!! Help!

I am trying to do a calculation to get the number of visits from my reports table summarised by date. I will explain the scenario;

When salesmen visit customers they log reports against them. These could be multiple reports on a single day. I have been told that its safe to assume there is only one customer visit per day for any given customer.

The sales person may do multiple reports for a visit he/she is doing on a particular day.

I need to get the number of total visits per customer, treating all reports (tagged as 'visits') for a particular day as one visit.

The relation is Customers to Reports on customer code and report tag 'visits'.

How do I go around doing this calculation?

Phew! I hope my explanation is adequate!

Thank you in advance.

[comment]

I need to get the number of total visits per customer, treating all reports (tagged as 'visits') for a particular day as one visit.

Find the reports of type "Visit" in the date range you want to report on, and sort them by Customer and by Date.

See here how to count the unique dates in each group:

http://fmforums.com/...post__p__289204