dashboards/system_tables/sql/reservation_utilization_month.sql [78:93]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  lsc.slot_capacity AS latest_capacity
FROM
  `region-{region_name}`.INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION jbo
-- Join the slot capacity history
LEFT JOIN reservation_slot_capacity rsc
  ON
    jbo.reservation_id = rsc.reservation_id
    AND jbo.creation_time >= rsc.start_time
    AND jbo.creation_time < rsc.end_time
-- Join the latest slot capacity
LEFT JOIN latest_slot_capacity lsc
  ON
    jbo.reservation_id = lsc.reservation_id
WHERE
  -- Includes jobs created 31 days ago but completed 30 days ago
  jbo.creation_time
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



dashboards/system_tables/sql/reservation_utilization_week.sql [83:98]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  lsc.slot_capacity AS latest_capacity
FROM
  `region-{region_name}`.INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION jbo
-- Join the slot capacity history
LEFT JOIN reservation_slot_capacity rsc
  ON
    jbo.reservation_id = rsc.reservation_id
    AND jbo.creation_time >= rsc.start_time
    AND jbo.creation_time < rsc.end_time
-- Join the latest slot capacity
LEFT JOIN latest_slot_capacity lsc
  ON
    jbo.reservation_id = lsc.reservation_id
WHERE
  -- Includes jobs created 8 days ago but completed 7 days ago
  jbo.creation_time
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



