"No value" as 0 in Time Series

Grafana Time Series Panel
1

Environment

OS: 6.12.21-4-MANJARO
Grafana: 11.6.0-pre
MariaDB: 11.7.2

Goal

I would like “no value”, that is dates where data is missing, to be interpreted as a data point with value 0.

Plan A

image

“Standard options > No value > What to show when there is no value” is set to 0.

image
image1621×849 97.8 KB

I expected this feature to generate data points that appear as zeros in the graph.

Other attempts

I followed several posts here in the forums that suggest using a Grafana macro like $__timeGroup(Date,‘1d’, 0), but I fail to incorporate it into my query:

image
image1618×825 72.5 KB

By my best attempt I get the error message “Data is missing a time field”.

Other suggestions were appending “vector(0)” SQL arguments to my formula or creating a calendar table. Maybe the latter works, but I would expect the “no value” feature to do the job and I would like to know whether it is possible at all.

Thank you in advance.

2

Hi,
If you execute your query from the first screenshot, what is the table result of that? Are all the other fields null, empty? Would something like this help?