Don't connect points when if timespan is over certain value

HI there,

I read this question multiple times, but didn’t find a solution for me yet.
I want the values not be connected if the time gab between 2 points is bigger than a certain value. I know there is a option where I can select “Don’t connect null values” but I have no null values.

Here is a snapshot of my data:

There is a gab of ~16hrs and here is the panel with this data:

I want to see this gab also in the panel. The values should not be connected if the time gap is bigger than 5seconds.
Is this somehow possible?

Here you can see my query how I get my data from the database:

1 Like

you could change config dynamically maybe with js through Apache ECharts plugin for Grafana | Grafana Labs
but it’s look like hard work.

But maybe you can rethink your data format and display, could you not sum your close point to get an unique point every 5 sec ?
by grouping by 5 sec delta and stack option you should be able to do something like that.

PS: to my knowledge you can’t change dynamically panel option, base on data value.

@julek23 have you found a solution to this?
I am looking for exactly the same myself, but I haven’t managed to find an easy way to do it.
Ideally, this could be an option in the panel

Hi, I add a nullvalue into my database if the time gab is over a certain value. I didn’t manage to do it within the panel.

Thanks for the update.
It is not easy in my case to insert null values in my case.

It would be great though if grafana had a panel option to not connect two points with a line if the time gap between them was of a specified value or higher.