Averages not working as expected

Content

Hi,

I'm running two sets of ROQL queries as follows:

SELECT Incident.Queue.LookupName as QUEUE, AVG(date_diff(CreatedTime,'2017-05-31 21:10')/86400) as 'AVG' FROM Incident WHERE Incident.StatusWithType.Status.LookupName NOT LIKE 'Resolved%' AND Incident.Category.LookupName IS NOT NULL AND Incident.Queue.LookupName IS NOT NULL GROUP BY Incident.Queue.LookupName ORDER BY Count(*) limit 1000

AND

SELECT Incident.Category.LookupName as Category, AVG(date_diff(CreatedTime,'2017-05-31 21:10')/86400) as 'AVG' FROM Incident WHERE Incident.StatusWithType.Status.LookupName NOT LIKE 'Resolved%' AND Incident.Category.LookupName IS NOT NULL AND Incident.Queue.LookupName IS NOT NULL GROUP BY Incident.Category.LookupName ORDER BY Count(*) limit 1000