title: PromQL query to find CPU and memory used for the last week
body: <p>I'm trying to write a Prometheus query that can tell me how much, as a percentage, CPU (and another for memory and network) each namespace has used over a time frame, say a week.</p>
  <p>The metrics I'm trying to use are <code>container_spec_cpu_shares</code> and <code>container_memory_working_set_bytes</code> but I can't figure out how sum them over time.  Whatever I try either returns 0 or errors.</p>
  <p>Any help on how to write a query for this would be greatly appreciated.</p>