# Display zero instead of no results

**URL:** <https://community.dynatrace.com/t/display-zero-instead-of-no-results/54408>\
**Category:** DQL\
**Tags:** dql\
**Created:** [December 16, 2025, 9:54am UTC](https://community.dynatrace.com/t/display-zero-instead-of-no-results/54408 "2025-12-16T09:54:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nc1](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@nc1](https://community.dynatrace.com/u/nc1)\
**Post date:** [December 16, 2025, 9:54am UTC](https://community.dynatrace.com/t/display-zero-instead-of-no-results/54408/1 "2025-12-16T09:54:00Z")

</div>

Hi,  
I’m trying to create a dashboard tile that will show the number of certificates getting close to expiry.

I have a DQL query that runs successfully but when there aren’t any certificates in the certificate lifecycle 1 : Between 10 and 30, it produces no results.  
My dashboard tile displays ‘no records’ if there are no results for this query, I want the dashboard tile to display a zero. This allows me to assign Thresholds to the dashboard tile so I can give it a red/green status, which I can’t do when there a no records. I thought adding a default value to the DQL would create an output of zero, but it doesn’t, I still get a result of ‘no records’.&nbsp; timeseries count(certificate.monitor.status, filter: {monitoring\_config == “My Certificate Monitoring” AND certificate\_lifecycle == “1: Between 10 and 30”}, default:0) Can anyone suggest a way to get value of zero when the DQL returns no results? Thanks

---

<div class="post-metadata">

**Author:** ![StrangerThing](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/strangerthing/32/12182_2.png) [@StrangerThing](https://community.dynatrace.com/u/StrangerThing)\
**Post date:** [December 16, 2025, 10:24am UTC](https://community.dynatrace.com/t/display-zero-instead-of-no-results/54408/2 "2025-12-16T10:24:00Z")

</div>

You’re going to have to use the “default” and “nonempty” parameters:

```markup
timeseries count(certificate.monitor.status, default:0), filter: {monitoring_config == "My Certificate Monitoring" AND certificate_lifecycle == "1: Between 10 and 30"}, nonempty:true

```

---

<div class="post-metadata">

**Author:** ![nc1](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@nc1](https://community.dynatrace.com/u/nc1)\
**Post date:** [December 16, 2025, 3:26pm UTC](https://community.dynatrace.com/t/display-zero-instead-of-no-results/54408/3 "2025-12-16T15:26:33Z")

</div>

Thank you. That has worked.
