Hi, I am trying to reproduce some of the SLA reports. I am executing the following query:
SELECT percentage(count(*), WHERE result='SUCCESS') FROM SyntheticCheck where monitorName='my monitor name' since 12 months ago facet monthOf(timestamp)
I expected a result similar to the one presented in the SLA reports tab, uptime line, when grouping by month.
The result from the NRQL is coming with everything at 100% whilst the SLA report comes with smaller percentages (small differences)
I would like to have access to the exact query used by Synthetics to create the Monthly SLA report, as my attempt is not working.