formula for average logged in time

[draacor]

I have a report that shows when someone logs in to a phone system each day. I want to take the total time they were logged in and divide it by the number of days they logged in for a given date range, and come up with an average. But im not sure how to do this in crystal because if i do a date range how do i differentiate the days of the week. The one stipulation i want tho, is it only counts as 1 day logged in if hte agent is logged in for more than 2 hours.

 

[lbass]

You need to show what fields are available to you along with some sample data at the detail level.

-LB

 

[draacor]

Ok hopefully i can explain better:

dbo.Agents: dbo.Login Time: dbo.logout.time
John Doe 2/1/2008 3:00AM 2/1/2008 7:00AM
2/2/2008 3:00AM 2/2/2008 12:00PM
2/3/2008 2:00AM 2/3/2008 11:00AM

Jane Doe 2/2/2008 5:00AM 2/2/2008 6:00AM
2/3/2008 7:00AM 2/3/2008 2:00PM
2/4/2008 7:00AM 2/4/2008 4:00PM

Bob Smith 2/3/2008 6:00AM 2/3/2008 3:00PM

Their are more fields in the report but the above is what im having trouble with. For example if i run a date range between 2/1/2008 and 2/4/2008, I want a formula that shows that John Doe has logged in 3 days during that date range. But with Jane Doe, I want it to only show 2 days because the first day she logged in it was only for an hour.

Hopefully this makes sense. I already have a field that calculates the total time they logged in during hte date range but it doesnt take into account the individual days so i can come up with an average.

 

[lbass]

So you would want to only calculate the average of time on for days with > 2 hours of log in time per agent, right?

Create three formulas:

//{@reset} for the agent group header:
whileprintingrecords;
numbervar timex;
numbervar dayx;
if not inrepeatedgroupheader then (
timex := 0;
dayx := 0
);

//{@accum} to be placed in the the detail section:
whileprintingrecords;
numbervar timex;
numbervar dayx;
if datediff("n",{dbo.Login Time},{dbo.logout.time}) > 120 then (
timex := timex + datediff("n",{dbo.Login Time},{dbo.logout.time});
dayx := dayx + 1
);

//{@displave} for the group footer:
whileprintingrecords;
numbervar timex;
numbervar dayx;
if dayx > 0 then
timex/dayx

This would show average minutes per day. You didn't say whether you wanted minutes/hours/seconds.

-LB