Select from multiple measurements

5

You should be able to generate this using a Nested query. It will be something like

  1. Align the Sum
  2. Perform the computation

select usage/capacity from (select sum(usage) as usage, sum(capacity) as capacity from usage,capacity group by time(1m)) group by time(1m)