I wanted to analyze the year on year or bi-yearly growth of the metrices stored in New relic using NRQL queries. I am trying something like below, but not getting desired result.

Background I have a job that reports the status of a dependency when the status changes. So it reports 0 if it goes down, and 1 when it goes back up. But it reports very rarely because the dependency is stable. The NRQL: FROM SomeEvent SELECT `service-status` Shows a table timestamp | service-status ————————– … […]