Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The method for calculating the number of events occurring every minute in InfluxDB is to use the "GROUP BY time()" clause in the InfluxQL query statement. This statement groups the data based on a time interval, such as every minute, and calculates the count of events within that interval. The resulting output will show the number of events occurring every minute in the specified time frame. The query syntax is as follows:

SELECT COUNT("fieldname") FROM "measurementname" WHERE time >= 'starttime' AND time <= 'endtime' GROUP BY time(1m)