NRQL: Continuous graph for LATEST query

Question

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
--------------------------
...       | 1
...       | 1

I have the NRQL:

FROM SomeEvent
SELECT latest(`service-status`)
TIMESERIES

But this just produces a graph with dots at the times of reporting.

Desired outcome

Instead of the dots, I'd like to have a line that indicates that the status is still 1, even if no new reports have ticked in.

In other words, it should "fill" the gaps with whatever the latest value is.

Faizan Shah · Accepted Answer · 2024-05-23 18:12:12Z

0

You could make use of new-relic filter in here,

FROM SomeEvent
SELECT filter(latest(`service-status`), where true)
TIMESERIES

answered May 23, 2024 at 18:12

Faizan Shah

14310 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alec Over a year ago

Thanks for the tip! But this now just produces one dot.

Faizan Shah Over a year ago

may be you could skip latest in here.

Collectives™ on Stack Overflow

NRQL: Continuous graph for LATEST query

Background

Desired outcome

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Background

Desired outcome

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related