Waste water treatment in pivot tables

Ricardo Méndez Escobar avatar Ricardo Méndez Escobar · · 2 min read
Waste water treatment in pivot tables

You can now build pivot tables and visualizations from your waste water treatment (WWTP) data — right alongside energy, water and carbon footprint.

Open the Visualization tab of any project, add a pivot table, and pick the new Waste water treatment category to slice your treatment-plant data any way you need.

What changed?

  • New “Waste water treatment” category in the custom-dashboard pivot builder.
  • 11 measures: CO₂e emissions, influent water (m³), discharged water (m³), sludge evacuated, biogas (recovered CH₄), plus BOD and COD organic-load ratios for the influent, sludge and discharge lines.
  • Correct aggregation by design: volumetric measures (m³, kg, CO₂e) are summed and prorated across the period; the BOD/COD ratios are shown as a per-record mean — so the totals row averages intensities instead of adding them up.
  • Break it down by water type (Domestic / Industrial), treatment name, facility, company, country, and year / quarter / month.
  • Operational and financial consolidation: the financial view weights the volumetric measures by ownership %, while the BOD/COD averages stay as averages.
  • Export to Excel and to a flat dataset, with fully translated headers and values.

Available now

It’s live for everyone — no setup needed if your facilities already have waste water treatment data. Just go to a project’s Visualization tab → Add visualizationPivot tableWaste water treatment.

Product UpdateVisualization

Collect once. Use everywhere.

See how Dcycle cuts reporting time by 70%, surfaces operational savings, and gives your auditors what they need, the first time.

See Dcycle in action