How to filter a timeseries based on a value?

badgerfifteen · ‎27 Oct 2025

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.