title: Prometheus average over a time period into Grafana table
body: <p>I can't seem to figure out the Prometheus query to calculate the single value of, say, average CPU usage per instance over a time period and create the Grafana table out of it:</p>
  
  <pre><code>Period: last 3h
  Instance A: CPU usage A
  Instance B: CPU usage B
  </code></pre>
  
  <p>Simply put, I want to:</p>
  
  <ol>
  <li>select a time period in Grafana</li>
  <li>have Prometheus average the values per instance within that period to a <strong>single value</strong></li>
  <li>use that data to populate a Grafana table</li>
  </ol>
  
  <p>Any hints?</p>
  
  <p>Thanks!</p>