I’m using Grafana to visualize several time series and I have set the legend to table showing the current and total values. A problem seems to be that my time series are not continuous in a way that a time-series can terminate at any time while new series can appear at any time.
This probably causes the undesirable behaviour that always the last known value of a series is treated as the current value of the series. I actually want Grafana to understand that a series has ended when no new observations arrive. While it is senseless wanting to remove such legend entries altogether, at least I want Grafana to set a current value of 0 when no further observations arrive.
Probably this is not possible in Grafana itself, but maybe I can handle this behaviour by a modified data query. I’m using MySQL as data source. Does anybody has advice how I could achieve this desired behaviour?