hint:
Referencing “_time” from previous query as “range(start: , stop:now())” for a following query. I can’t get it to work - InfluxDB 2 - InfluxData Community Forums
If I have some free time I will return with the solution, I have done what you are asking multiple times…