L
Love Buzz
Hello all.
Below is a query I am trying to create that contains operator productivity
statistics. In addition, I would like to calculate the average time per day
(for the period I select). The .csv file that I am using uses seconds, so I
have to calculate to make the result hours. That works great, but I can't
seem to get the average. I get the message I put in the subject line.
Any assistance would be appreciated.
SELECT [December 4].UserID, [December 4].Queu, [December 4].Function,
Sum([December 4].Items) AS SumOfItems, Sum([December 4].timeinqueu) AS
SumOftimeinqueu, Sum([December 4]![timeinqueu]/"60"/60) AS Expr1, [Queus and
SLAs].SLA, [SumOfItems]/[Expr1] AS Expr2, [Expr2]/[SLA] AS Expr3,
Avg(Sum([December 4]![timeinqueu]/"60"/60)) AS Expr4
FROM ([December 4] INNER JOIN [Returns Associates] ON [December 4].UserID =
[Returns Associates].[User ID]) INNER JOIN [Queus and SLAs] ON ([December
4].Queu = [Queus and SLAs].[Queu Number]) AND ([December 4].Function = [Queus
and SLAs].Function)
WHERE ((([December 4].Date) Between [StartDate] And [EndDate] And ([December
4].Date) Between [StartDate] And [EndDate] And ([December 4].Date) Between
[StartDate] And [EndDate]))
GROUP BY [December 4].UserID, [December 4].Queu, [December 4].Function,
[Queus and SLAs].SLA
HAVING ((([December 4].UserID) Like [Enter Employee User ID] & "*"));
Below is a query I am trying to create that contains operator productivity
statistics. In addition, I would like to calculate the average time per day
(for the period I select). The .csv file that I am using uses seconds, so I
have to calculate to make the result hours. That works great, but I can't
seem to get the average. I get the message I put in the subject line.
Any assistance would be appreciated.
SELECT [December 4].UserID, [December 4].Queu, [December 4].Function,
Sum([December 4].Items) AS SumOfItems, Sum([December 4].timeinqueu) AS
SumOftimeinqueu, Sum([December 4]![timeinqueu]/"60"/60) AS Expr1, [Queus and
SLAs].SLA, [SumOfItems]/[Expr1] AS Expr2, [Expr2]/[SLA] AS Expr3,
Avg(Sum([December 4]![timeinqueu]/"60"/60)) AS Expr4
FROM ([December 4] INNER JOIN [Returns Associates] ON [December 4].UserID =
[Returns Associates].[User ID]) INNER JOIN [Queus and SLAs] ON ([December
4].Queu = [Queus and SLAs].[Queu Number]) AND ([December 4].Function = [Queus
and SLAs].Function)
WHERE ((([December 4].Date) Between [StartDate] And [EndDate] And ([December
4].Date) Between [StartDate] And [EndDate] And ([December 4].Date) Between
[StartDate] And [EndDate]))
GROUP BY [December 4].UserID, [December 4].Queu, [December 4].Function,
[Queus and SLAs].SLA
HAVING ((([December 4].UserID) Like [Enter Employee User ID] & "*"));