Need Help in KPI SWQL query

Hi 

Can any one generate SWQL query to get % Availability of 7 Days , Last month.

Mention query is of Today's Availability.

SELECT Availability
     , Status
     , Color
FROM (
     SELECT ROUND(AVG(rt.Availability), 2) AS Availability
          , 'UP - ' + SubString(tostring(DATETRUNC('day', GETDATE())), 0, 12) AS Status
          , '#30b230' AS Color
     FROM Orion.ResponseTime rt
     WHERE rt.node.customproperties.SP_Media = 'fiber'
          AND DATETIME > DATETRUNC('day', GETDATE())
     )
GROUP BY rt.node.CustomProperties.SP_Media
     , month(DATETIME)