I’ve been struggling with this problem for quite a while now. In any visualization that involves time, if a row is missing it’s a very frustrating experience to set that to zero.
Unfortunately “Standard options > No value” doesn’t work when rows are missing. Frustratingly “Graph styles > Connect null values” requires a Threshold to operate but that Threshold is unable to reference $__interval.
Resample can work in some cases but our only real option is “fillna”. We then need additional transformations to convert NaN into 0. Consequently, a “fillzero” option would be much more useful here.
Unfortunately, Resample doesn’t work with multi-frame time series.
I’ve scoured this forum for solutions and it seems that the answer is “fix it in the query”. Truly is there no option to just “fill with zero” a timeseries? I don’t want to solve it in the query because I’m using a columnar datasource with no time fill function. I feel like Grafana should be more capable here and offer a solution.