Re: Analyzing Calls

Dale E. Reed Jr. ( (no email) )
Mon, 21 Jul 1997 15:46:29 -0700

Wayne Jordan wrote:
>
> Average per user

Try this:

Select UserName, Hrs=(Sum(AcctSessionTime)/3600)
From Calls
Group By UserName
HAVING Sum(AcctSessionTime) > 1800
Order By UserName
Compute Avg((Sum(AcctSessionTime)/3600))

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com