I have a problem summarizing the last values from my series. The series gets updated at the same time (every minute), but not every series gets an update. So the following query mixes current and older values:
SELECT sum(“last”) FROM (SELECT last(“value”) FROM “dbi_value” WHERE timeFilter GROUP BY time(__interval), “type_instance” fill(null)) WHERE timeFilter GROUP BY time(__interval) fill(previous)
How can I only sum up values from the same time range (same minute)? The Series which have no value for a time range should be ignored.
Thanks in advance!