How to filter a timeseries based on a value?

badgerfifteen — Tue, 28 Oct 2025 06:33:59 GMT

Hi,

I am in the process of creating a dashboard where it shows the synthetic availability of all our synthetics in our environment.

We have a diverse amount of synthetics which run from 5 mins to 10mins and what I am trying to achieve is, using the Heatmap visual, show the execution status and availability of our synthetics. Here is the current code that I have:

timeseries interval:5m, {status = avg(dt.synthetic.browser.availability)}, {executions = count( dt.synthetic.browser.executions)}, by: {dt.entity.synthetic_test} | fieldsAdd synth_name = entityName(dt.entity.synthetic_test)

This is what should appear if you map the values to 'status'

Now when you map it to 'executions' (i.e. when it actually executes) you get the following:

I would like to have a union where if executions = 1, then capture the availability for that time. Any ideas? Using just status is inaccurate when showing availability.

Re: How to filter a timeseries based on a value?

IzabelaRokita — Wed, 17 Dec 2025 10:04:06 GMT

Hey @badgerfifteen ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

topic Re: How to filter a timeseries based on a value? in DQL

How to filter a timeseries based on a value?

Re: How to filter a timeseries based on a value?