I’d like to compute the count of data points seen over the last 5m, and compute that every 10s. Using a continuous query.
I normally do that with a
SELECT count(field) and
WHERE time > now() - 5m. When I create a continuous query, it requires me to set a GROUP BY to be able to use the count().