Query not grouping

[dbaker5204]

I have a query that is not grouping by Team. Currently it is grouping by Agent name, Supervisor, Date and it set to group by team, however, it is listing the teams separately. The Teams are linked to a table that lists the queue number and name, and the queue numbers and names are different for each, but shouldn't it still group if the team is the same? SQL is below:


SELECT [HelpDataNew Query].HelpDate, [HelpDataNew Query].AgentName, [HelpDataNew Query].Supervisor, [HelpDataNew Query].Team, Sum([HelpDataNew Query].ACDCalls) AS SumOfACDCalls, Sum([HelpDataNew Query].ACDTime) AS SumOfACDTime, Sum([HelpDataNew Query].ACWTime) AS SumOfACWTime, Sum([HelpDataNew Query].HoldTime) AS SumOfHoldTime, Sum([HelpDataNew Query].ExtInCalls) AS SumOfExtInCalls, Sum([HelpDataNew Query].ExtInTime) AS SumOfExtInTime, Sum([HelpDataNew Query].ExtOutCalls) AS SumOfExtOutCalls, Sum([HelpDataNew Query].ExtOutTime) AS SumOfExtOutTime, Sum([HelpDataNew Query].HeldCalls) AS SumOfHeldCalls, Sum([HelpDataNew Query].TransOutCalls) AS SumOfTransOutCalls, (IIf([ACDCalls]=0,0,([ACDTime]+[ACWTime]+[HoldTime])/[ACDCalls]))/86400 AS AHT2, [HoldTime]/86400 AS HOLDT, [ExtInTime]/86400 AS [InT], [ExtOutTime]/86400 AS OUTT
FROM [HelpDataNew Query]
GROUP BY [HelpDataNew Query].HelpDate, [HelpDataNew Query].AgentName, [HelpDataNew Query].Supervisor, [HelpDataNew Query].Team, (IIf([ACDCalls]=0,0,([ACDTime]+[ACWTime]+[HoldTime])/[ACDCalls]))/86400, [HoldTime]/86400, [ExtInTime]/86400, [ExtOutTime]/86400
HAVING (((Sum([HelpDataNew Query].ACDCalls))>0));

 

[arnelgp]

rearrange your Group By and put Team as the first in the list, then supervisor, agentname, date, etc.

 

[CJ_London]

shouldn't it still group if the team is the same?

only if all the other fields are the same as well. If you look at the result, you will probably find you have different values in helpdate or most likely agentname, etc.

Remove these columns and you will get the result required -

 

[plog]

I'm only trying to be half a shit-head with this - It groups by everything in the GROUP BY.

So, every unique permutation of the items in the GROUP BY will appear in their own record. Which means for every unique value in this calculation:

(IIf([ACDCalls]=0,0,([ACDTime]+[ACWTime]+[HoldTime])/[ACDCalls]))/86400, [HoldTime]/86400, [ExtInTime]/86400, [ExtOutTime]/86400

Will be in its own record. Did you intend to GROUP BY that calculation?

 

[dbaker5204]

Thanks, that fixed it.