https://community.dynatrace.com/t5/DQL/Display-zero-instead-of-no-results/m-p/291556#M2879 <P>Hi,<BR />I'm trying to create a dashboard tile that will show the number of certificates getting close to expiry.&nbsp;</P><P>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.<BR />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</P> Tue, 16 Dec 2025 09:54:00 GMT nc1 2025-12-16T09:54:00Z https://community.dynatrace.com/t5/DQL/Display-zero-instead-of-no-results/m-p/291556#M2879 <P>Hi,<BR />I'm trying to create a dashboard tile that will show the number of certificates getting close to expiry.&nbsp;</P><P>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.<BR />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</P> Tue, 16 Dec 2025 09:54:00 GMT https://community.dynatrace.com/t5/DQL/Display-zero-instead-of-no-results/m-p/291556#M2879 nc1 2025-12-16T09:54:00Z https://community.dynatrace.com/t5/DQL/Display-zero-instead-of-no-results/m-p/291558#M2880 <P>You're going to have to use the "default" and "nonempty" parameters:&nbsp;</P><LI-CODE lang="markup">timeseries count(certificate.monitor.status, default:0), filter: {monitoring_config == "My Certificate Monitoring" AND certificate_lifecycle == "1: Between 10 and 30"}, nonempty:true</LI-CODE> Tue, 16 Dec 2025 10:24:00 GMT https://community.dynatrace.com/t5/DQL/Display-zero-instead-of-no-results/m-p/291558#M2880 StrangerThing 2025-12-16T10:24:00Z https://community.dynatrace.com/t5/DQL/Display-zero-instead-of-no-results/m-p/291588#M2881 <P>Thank you. That has worked.</P> Tue, 16 Dec 2025 15:26:33 GMT https://community.dynatrace.com/t5/DQL/Display-zero-instead-of-no-results/m-p/291588#M2881 nc1 2025-12-16T15:26:33Z