NPM Group availability report in swql

There is already a report prebuilt for group availability. You can copy that and change the time.

BUT, if you need the SWQL here is an example:

SELECT 
C.Name AS [GroupName],
AVG(CS.PercentAvailability) AS [Availability]
FROM Orion.ContainerStatus CS
INNER JOIN Orion.Container C ON CS.ContainerID=C.ContainerID
WHERE CS.DateTime>ADDHOUR(-24,GETDATE())
GROUP BY C.Name

its showing all group = 100 % , which is wrong 

Need

Group = ATM Branch

availability = Yesterday