Skip to main content

Reports

Mango provides several tools for extracting, aggregating, and presenting historical data. Whether you need automated Excel reports delivered by email, statistical summaries for energy analysis, or CSV exports for external tools, the reporting features covered in this section address these needs.

Key Concepts​

  • Rollups aggregate raw point values into summarized intervals (e.g., hourly averages, daily maximums). This is essential for working with high-frequency data over long time periods.
  • Statistics provide summary metrics for a time range: average, minimum, maximum, sum, count, delta, runtime, and more. The available statistics depend on the data type (numeric, binary, multistate, or alphanumeric).
  • Excel Reports use Excel template files with named ranges. Mango fills in the data and delivers the completed report as a download or email attachment.
  • CSV Export provides a simple way to get raw or rolled-up data out of Mango for use in external tools.

In This Section​

  • Creating Excel Reports -- Set up report templates, configure time periods and rollups, schedule automated runs, and deliver reports via email.
  • Rollups and Statistics -- Detailed reference for all rollup types (average, delta, integral, accumulator, etc.) and statistical calculations available for each data type.
  • Rollup UI Component -- How to use rollup controls in the date bar, configure per-point default rollups, and use the Simplify algorithm for efficient charting.
  • Extended CSV Export as Template -- Step-by-step guide for using an extended CSV export as a reusable import template.