I think that should be solved on the query level, e.g. union/join real result set with set of zeroes - so result set will have key with zero, for keys which are missing in real result set. Answer from jangaraj on community.grafana.com
🌐
Grafana
community.grafana.com › t › fill-null-not-working-as-expected › 2837
Fill(null) not working as expected - Grafana - Grafana Labs Community Forums
September 19, 2017 - Hello Everyone. I’ve got a query/line graph that isn’t behaving as expected. Where there are no points reported, using the “fill(null)” option should just show empty space. This is not the case. I found several issues o…
🌐
Grafana
community.grafana.com › dashboards
Populate null values - Dashboards - Grafana Labs Community Forums
April 16, 2024 - Hello, Suppose we have a “Table view” that looks like this: Key Value 500 0.462 1000 0.418 1500 0.382 2500 0.198 3000 0.167 You’ll notice that if we want entries for every increment of 500 in the key, then the key 2000 is missing from the table. The increment value is defined by a dashboard ...
Discussions

Time series: how to set nulls as zero?
What Grafana version and what operating system are you using? Docker Grafana 8.1.5 What are you trying to achieve? Plot a Prometheus Counter with various labels as a time series, and fill all null/missing values as zeros. How are you trying to achieve it? Using time series graph. More on community.grafana.com
🌐 community.grafana.com
9
2
October 1, 2021
Fill No Data with 0 for calculations
I am trying to do simple addition using Transform : Add field from calculation. But when one of the field is having no data the calculation don’t work. To fix that I tried to fill it with 0, but it is not working. My query looks like this: SELECT sum(diff) from ( select non_negative_diff... More on community.grafana.com
🌐 community.grafana.com
9
0
December 22, 2021
Add fill(0) and fill(null) option to InfluxDB query editor
Otherwise fill(0) will insert zeros where there should not be any. There is also a info panel if you click on the links there a detailed help will be shown. To enter a lower limit for group by specify: >60s (if your write rate is 60s) This is now solved pretty with a pretty good solution. Please be aware of that master and next release has some breaking changes for InfluxDB users. Read about those here: https://github.com/grafana... More on github.com
🌐 github.com
0
September 4, 2014
Fill missing values with zero
I’ve been struggling with this problem for quite a while now. In any visualization that involves time, if a row is missing it’s a very frustrating experience to set that to zero. Unfortunately “Standard options > No value” doesn’t work when rows are missing. More on community.grafana.com
🌐 community.grafana.com
1
0
March 6, 2026
🌐
Grafana
community.grafana.com › graph (old) panel
Time series: how to set nulls as zero? - Graph (Old) Panel - Grafana Labs Community Forums
October 1, 2021 - What Grafana version and what operating system are you using? Docker Grafana 8.1.5 What are you trying to achieve? Plot a Prometheus Counter with various labels as a time series, and fill all null/missing values as zeros. How are you trying to achieve it? Using time series graph.
🌐
Grafana
community.grafana.com › influxdb
Fill No Data with 0 for calculations - InfluxDB - Grafana Labs Community Forums
December 22, 2021 - I am trying to do simple addition using Transform : Add field from calculation. But when one of the field is having no data the calculation don’t work. To fix that I tried to fill it with 0, but it is not working. My query looks like this: SELECT sum(diff) from ( select non_negative_difference(“value”) as diff FROM “counter” WHERE (“tag_name” = ‘tag1’) AND $timeFilter fill(0) ) Same case is with many other queries also, any way to replace no data with 0?
🌐
GitHub
github.com › grafana › grafana › issues › 756
Add fill(0) and fill(null) option to InfluxDB query editor · Issue #756 · grafana/grafana
September 4, 2014 - Otherwise fill(0) will insert zeros where there should not be any. There is also a info panel if you click on the links there a detailed help will be shown. To enter a lower limit for group by specify: >60s (if your write rate is 60s) This is ...
Author: grafana
🌐
Grafana
community.grafana.com › t › fill-missing-values-with-zero › 161995
Fill missing values with zero - Grafana - Grafana Labs Community Forums
March 6, 2026 - I’ve been struggling with this problem for quite a while now. In any visualization that involves time, if a row is missing it’s a very frustrating experience to set that to zero. Unfortunately “Standard options > No value” doesn’t work when rows are missing.
Author: tarantool
Find elsewhere
🌐
Reddit
reddit.com › r/grafana › problem with time series null values
r/grafana on Reddit: Problem with time series null values
March 23, 2023 -

Hello everyone,

I hope you can help me with this situation.
I have a time-series graph on my grafana.
If I have the Connect Null Values set as Always it appears this way:

If I set to Never it appears this way:

Is there a way to make the line continue on 0 instead of this breaks when the Never option is set or the connecting line that doesn’t show the correct value when the Always option is set?

The data comes from Elasticsearch and in some timestamps there are no results, so I need the line to stay continuous at 0.
Here is the current config I have:

None of this configs work :(

Could you help me solving this?

Thank you so much!

🌐
Grafana
community.grafana.com › time series panel
How to display '0' for series value when value is null? - Time Series Panel - Grafana Labs Community Forums
April 20, 2018 - We have a timeseries panel that is showing data from several categories (series). When one of the series is has no data available, i.e. is null, the tooltip snaps to the nearest value when hovering over the chart: Ra…
🌐
GitHub
github.com › grafana › grafana › issues › 11402
No graph when ‘null value’ is not set to connected , while there are no holes in database · Issue #11402 · grafana/grafana
March 27, 2018 - ubuntu 16.04 influxdb: 1.4.2.1 telegraf: 1.5.2.1 grafana: 5.0.0 telegraf collect interval is: 2 seconds grafana $__interval is: 2 seconds. Stackin/null value / Null value is set to : null in the ‘group by’ query, fill null is set.
Author: grafana
🌐
Grafana
community.grafana.com › dashboards
Transform - Reduce Row is filling "0" for rows with missing values - how to prevent? - Dashboards - Grafana Labs Community Forums
June 3, 2023 - I have a simple problem (hopefully): I have four signals (a1, a2, a3, b1) that I am visualizing on Grafana in a single Timeseries panel. Signals a1, a2, a3 are sampled at one rate (say, once per minute), while signal b1 is sampled faster (once per second). I am using Transform → Reduce Row ...
🌐
GitHub
github.com › grafana › grafana › issues › 79315
InfluxDB: Show a notification when fill(null) and reduce expression with strict mode · Issue #79315 · grafana/grafana
December 11, 2023 - When Reduce strict mode is used, fill(null) (Influxql function) will result in NaN. See docs https://grafana.com/docs/grafana/latest/panels-visualizations/query-transform-data/expression-queries/#sum This is a confusion for the users who...
Author: grafana
🌐
Grafana
community.grafana.com › dashboards
Insert '0' when no data point is available on timeseries charts - Dashboards - Grafana Labs Community Forums
March 19, 2024 - I am charting a timeseries data source, but there are some points missing for two reasons: A particular day/time has no entry The particular statistic has stopped reporting (i.e. because the load on it has stopped) Is…
🌐
GitHub
github.com › grafana › grafana › discussions › 43093
Null as zero for new timeseries panel · grafana/grafana · Discussion #43093
The graph display works, but the new time series graph is missing an option that the Graph (old) has under Display > Stacking and null value > null value: null as zero, hence we now end up with broken lines for null values. What did you expect to happen? I was expecting an option to fill nulls as zeros in the time series.
Author: grafana
🌐
GitHub
github.com › grafana › grafana › issues › 7829
[Feature Request] Stack Display with 'fill(none)' will not render correctly · Issue #7829 · grafana/grafana
March 14, 2017 - What OS are you running grafana on? debian:jessie · What Browser: Windows Firefox 52.0 64-bit · What did you do? I created a Graph with fill option null and display option stack. SELECT sum("value") FROM "teststack" WHERE $timeFilter GROUP BY time($interval), "user" fill(none) What was the expected result?
Author: grafana
🌐
Stack Overflow
stackoverflow.com › questions › 55766758 › how-to-show-time-since-last-null-value-on-grafana
t sql - How to show time since last null value on Grafana - Stack Overflow
Copy SELECT ("value") FROM "measurement" WHERE ("host" = 'IP.ADDRESS' AND "and" = 'null') AND $timeFilter GROUP BY time(365d) fill(null) Where value, measurement, and IP.ADDRESS are all filled in with the correct information. I know what I have is wrong, but I am not sure what to put. Ideally what I am trying to say in the query is display the last time since the value displayed on grafana was null in the last 365 days.