Re: Average Monthly Usage Report

Dale E. Reed Jr. ( (no email) )
Thu, 12 Nov 1998 17:10:23 -0800

Robert H. Clugston wrote:
> List,
> I'm trying to right a report to find out what kind of usage my users are
> doing as a group. The report we've been doing by hand breaks up users usage
> into groups of 30 mins. For ex. 57.1% of our users used 0-30 mins for the
> Month of June and 15.9% used 31-60 and so on.
> What I would like to know is which table will return minutes used per user
> for a given month. Also, how would I return this data (a formula would
> help.)

The CallHistory table has the anniversary summary for the user. Its
not a per-month summary. For example, it will show a date of 9/13/98
and 4 hours. This means from 9/13-10/13 the user sued 4 hours.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |