Link to home
Create AccountLog in
Avatar of Dan560
Dan560Flag for United Kingdom of Great Britain and Northern Ireland

asked on

average calculation help

Hi,

I host a helpdesk package for a users in multiple offices

I need to work out the average number of concurrent license used per office. I can fetch my log files as far back as 8 days. In my data I have the following

Login time
Log in Date
user
Country

I am not sre what calclation is needed to get the average. Can someone help?
SOLUTION
Avatar of MajorBigDeal
MajorBigDeal
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Do you record any information about when the user logs out? Without that, you can't actually tell the state of the user's login status, all you can tell are the specific instances in time that they logged in, which could happen multiple times a day and still constitute only a single license.

For example, UserA, B, C and D could all log in at different times of the day, multiple time a day. If you don't have logout times, then there is no way to tell if they were all logged in at once, or if they took turns.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Avatar of phoffric
phoffric

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of phoffric
phoffric

You may be interested in looking at Interval Trees.

Here is a discussion of drawing overlapping intervals, but it also includes source code IIRC which determines where the overlaps occur:
    https://www.experts-exchange.com/questions/26471944/Mulitple-Intersecting-Calendar-Appointment-Drawing-Drawing-Position-Calculation-of-Appointments-with-overlapping-times.html

The following discussion determines overlaps if the records are in a database (and, here, there is a log out time as well):
    https://www.experts-exchange.com/questions/27771457/Overlapping-time-intervals-query.html
I need average number of concurrent license used per office

I have
Login time
Log in Date
user
Country

Do you have any relationship between users and offices?
Between logins and license use?