State Timeline not connecting

Grafana
,
1

I have a state timeline I have mostly set up. It’s SQL based. I have this working as expected in another Prometheus data based timeline. The data from the query basically flips the bit on or off. It’s kinda working, but its like the other rows are interrupting each other. We are currently on v8.1.5

image
image1272×372 16.1 KB

Any idea what I can do to show a continues line that flips between states for each numbered row?

2

I am having the same issue. I’m using sql data. It is fine if there is only 1 metric column but with multiple my data has nulls.
I can’t work out how to change the nulls to the last value in the column.

image
image1041×162 4.37 KB

3

I don’t have nulls, just time line of on/off.
image

4

it all connects if I filter it to 1 terminal:

image
image1353×755 43.3 KB