Hi
I am always getting different result as compare to SWQL Query and Web Report Writer.
Mentioned is Report of Average Availability LAST MONTH.
SWQL Result:
SELECT concat(round(avg(Availability), 2), ' %' ) as supernet FROM Orion.ResponseTime rt where monthdiff(datetime,getdate())=1 and rt.Node.CustomProperties.SLA_LTE ='supernet'
Web Report Result: