AnsweredAssumed Answered

I have a large database with 120,000 records or cases. The fields I have are "Name of provider" and "date of case" among others of course. This is very simple I'm sure but I want to know, for each provider in a date range how many days they worked as a re

Question asked by idwal on Dec 28, 2015
Latest reply on Dec 29, 2015 by Mike_Mitchell

I have a large database with 120,000 records or cases. The fields I have are "Name of provider" and "date of case" among others of course. This is very simple I'm sure but I want to know, for each provider in a date range how many days they worked as a report?

 

I have made a nice report that details the number of cases per provider in a date range but cannot figure out how to get the days worked count right...!

 

Thanks

Outcomes