I struggle with a SELECT from multiple measurements computing a single result per time interval.
- one measurement has resource usage breakdown by user
- other measurement instruments installed capacity
The number of points per time interval is not the same for both measurements (usage even varies over time). Now I would like to compute utilization like
select sum(usage)/sum(capacity) from usage,capacity group by time(1m)
Unfortunately influx runs the same query against each measurement, finding one of the two sum() values undefined in each case. Did I miss something in the syntax where I can specify which measurement the field should come from?