You did not say which time series db you are using (is it ElasticSearch?). Can you not just to do a group by/aggregation?
Here is an example with ElasticSearch:
Here is an example with InfluxDB:
You did not say which time series db you are using (is it ElasticSearch?). Can you not just to do a group by/aggregation?
Here is an example with ElasticSearch:
Here is an example with InfluxDB: