Hello, I have a simple query and visualization, a MariaDB database:
Now this works nicely - it basically counts the total number of the row which have a valid ID throughout time.
But as in the topic title, I would like to achieve “carrying” the last non-null value forward to the selected Grafana end time - but ONLY when there is a gap between the final non-null value and the end time.
I have one idea on how to do it - to create a “virtual” data point at the end time so that the values connect (I have connect null values ON as you can see in the pic).
I really would want some help on how to achieve this in the MariaDB / MySQL query.
I have researched on this on the net but found only some folks talking about how to do something similar in InfluxDB only. Also, MariaDB has some kind of a LAST() function - but I need help on how to use it in the query too and so that Grafana understands what I need to do.
Thank you so much for ANY help! I preciate’ it 