How to aggregate time in InfluxDB?

Question

Database

There is a piece of iron that throws the mode in which it works on the server. Number 0-3.
I need to get statistics: how long the piece of iron has worked in each mode for the period, the maximum and minimum continuous operating time in each of the modes.
Is it possible to get such data by request in influx?
Perhaps not influx, but some other solution. Piece of iron can be several hundreds or thousands, and for each time per minute it is necessary to obtain and analyze data on the operating time of the modes.