topic Single Value showing "no data" when value is 0 in Dashboarding

Single Value showing "no data" when value is 0

Constantin — Wed, 08 Apr 2026 11:36:43 GMT

Hey everyone,

I want to create a single value that displays a number of issues found, so it should display 0 if none are found. While tinkering with it, I noticed that single value always displays "No data available" when using this DQL structure:

data record(a=0)
| append [
data record (a=0)]

| summarize sum(a)

It does display 0 if the value is not summarized.

I also tried using coalesce, which was recommended in a different post, but it did not change anything. How do I get the single value to display 0 in this case?

Re: Single Value showing "no data" when value is 0

t_pawlak — Wed, 08 Apr 2026 12:11:54 GMT

Hi,

I tested this in my environment.

When using a synthetic record like this:

data record(a=0) | summarize value = count() | append [ data record(value = 0) ] | summarize value = max(value)

the result is 1, because count() counts the row that was artificially created by data record(a=0). So this is expected DQL behavior.

With sum(a), the resulting value is 0, but the Single value tile still shows No data available.
So the issue does not seem to be coalesce() itself, but rather how the Single value visualization handles summarized results based on synthetic records.

What worked for me was using the same fallback pattern on real queried data, for example:

fetch dt.davis.problems | filter event.status == "ACTIVE" | summarize value = count() | append [ data record(value = 0) ] | summarize value = max(value)

This worked correctly in my tests. When matching problems existed, the tile showed the real count
when nothing matched, the tile showed 0 instead of No data available

I also tested it with different filters, and the Single value changed accordingly (0, 1, 32, etc.), so this workaround seems reliable when used on actual fetched data rather than only on synthetic data record(...) input.

Look, depending on which filter I used for event status, the Single value changed accordingly — 0, 1, 32, etc.

Re: Single Value showing "no data" when value is 0

bpgrady_cig — Wed, 08 Apr 2026 15:46:42 GMT

We are seeing this as well. We used have dashboards showing 0.00% now showing no data. Will display 0 when it is a long, but if it is a double we get "no data available". This is only for Single Value Displays, records and tables properly show a 0.00 value double.

Re: Single Value showing "no data" when value is 0

Shubham007 — Wed, 08 Apr 2026 16:18:48 GMT

Hello Team,

This has been identified as a bug from the Dynatrace side, and our teams are actively working on fixing it. The issue will be resolved at the earliest possible.

Thank you for your patience and understanding.

Regards,
Shubham

Re: Single Value showing "no data" when value is 0

Shubham007 — Thu, 09 Apr 2026 09:43:46 GMT

Hello Team
You can refer this also :Dashboards 1.336.2 "No data available" for some Single value tiles - Dynatrace Community