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

Grafana Dashboards
,
1

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:

database
database1254×234 12.6 KB

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

Panel
Panel1247×370 39.9 KB

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: https://community.grafana.com/t/use-variables-to-filter-data-and-use-varibale-name-as-metric-name/70425

1 Like
2

hello,
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.

3

@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

4

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.

5

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.

6

Hi,
did you find a solution for this problem?
I have the same problem sind 2 years and did not find any solution…