Plot when count is zero

[elastic21]

Is there a way to plot time series graph so that there are bars when records count is 0 and no bars when records count is > 0 ? Given a time interval is selected for plotting (say 30min) for the data in last 24hrs ?

So, essentially showing when there was no data.

[majagrubic (Maja)]

I'm afraid that's not possible. How would the bar look like when record count is 0 if it were to have height?

[Marco_Liberati]

That's an interesting case, I think that is technically possible with some Lens formula magic.

In this example I've used two filters: in one case there's a file extensions that does not exists in the dataset, in the other case "css", which is known to be there.

For the metric side I've using this formula:

-1 * clamp(count(), 0, 1) + 1

Perhaps a table would suffice as well: