Re: Analyzing Calls

Dale E. Reed Jr. ( (no email) )
Fri, 25 Jul 1997 10:48:41 -0700

Wayne Jordan wrote:
> How would I do this to get the monthly avg of each customer?

See below.

> What does the > 1800 do the equation?

It only includes users calling a total of 30 mins or more. You
can drop that line altogether.

Select UserName, Mon=DatePart(Month, CallDate),
From Calls
Group By UserName, DatePart(Month, CallDate)
Order By UserName, DatePart(Month, CallDate)
Compute Avg((Sum(AcctSessionTime)/3600)) by UserName

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