Problem with time series null values

Grafana Dashboards
, , ,
1

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:

imagem
imagem1482×244 35.7 KB

If I set to Never it appears this way:

imagem
imagem1523×237 30.9 KB

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:

imagem
imagem1538×715 74 KB

imagem
imagem
imagem355×531 16.9 KB

imagem

None of this configs work :frowning:

Could you help me solving this?

Thank you so much!

2

Hi @barbosaa123474,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

  • Which panel visualisation you are using?

  • What Grafana version are you using?

Thanks

3

Hi, @usman.ahmad, I have the same problem, The dashboard is left without visualization. Changing time does the same. I’m using Grafana v10.3.3 (252761264e) Version

sin data
sin data1178×513 57.7 KB

4

hi, i have the same problem, version 10.0.13

5

I have the same problem, I have two time series query to plot in the line chart with different time and the connect to null does not work and both lines start and end at zero which is undesired. Anyone found solution to this?
@ thiagoaoshi
@ claudiodigenaro
@ barbosaa123474

1 Like
6

Could you provide an example of your current chart and the desired one? As well as some sample data.

7

@ebabeshko
I have two query A and B, A data is before current time and B data is after current time. I want to have solid line for A data and dash line for B data with stacking for Type columns. First figure is where I have stack charts but the values from A, B connect to 0 with null values which is not desired

image
image1380×366 46.1 KB

image

I want to have the chart like below but with stack = normal

image
image1380×355 42.9 KB

image

sample data:

time_group Type A count Type B count Total count Type A future count Type B future count Total future count
7/16/2024 0:00 4000 9100 75000
7/16/2024 0:05 4005 9000 76001
7/16/2024 0:10 4500 8000 78000
7/16/2024 0:15 3800 8500 75000
7/17/2024 19:00 10100 20600 70000
7/17/2024 20:00 9800 22000 71000
7/17/2024 21:00 9500 17800 71100
7/17/2024 22:00 8500 15000 72100
9

Something similar was raised here, although no solution was provided

10

@ ebabeshko yes, I saw the same post. Any recommendations/ suggestions for this from your end?

11

You’ve already opened an issue, let’s hope it would be fixed