Versions Compared

Old Version 1

changes.mady.by.user Richard Sanigar

Saved on

compared with

New Version 2

changes.mady.by.user Emma Apted

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Here are the queries used to generate each section, as of today:

Total DWS Traffic
Code Block
languagesql
collapsetrue
SELECT period,year,month,volume_in,volume_out
FROM reports.excel_yearly_volumes
WHERE (excel_yearly_volumes.project='DWS')
AND (excel_yearly_volumes.circuit_usage='Interconnect')
AND (excel_yearly_volumes.period >= '201711')
AND (excel_yearly_volumes.period <= '201810')
ORDER BY period ;