"moving count" in CQs


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().