Totalizers

Prev Next

Overview

In Bazefield, a Totalizer is a specialized point type that aggregates raw SCADA data over a regular time interval. They are ideal for summarizing telemetry like energy production, average irradiance, or peak voltage. Calculated Points can do the same, but Totalizers run at the Edge, enabling time-based insights without external processing.

Totalizer data is typically stored in the Bazefield IMATIS database or an external database like PostgreSQL—similar to Interval Calculations.


Key Capabilities

ℹ️ Time-Based Aggregation

Totalizers compute values over a defined interval (e.g., 5 minutes, 1 hour).

  • Example: Sum of power over the last 5 minutes  

  • Example: Maximum voltage in the last 5 minutes

ℹ️ Flexible Aggregation Types

Supported operations include:

  • Sum

  • Time-Weighted Average

  • Maximum

  • Minimum

  • Standard Deviation

ℹ️ Real-Time KPI Generation

Totalizers are often used to feed dashboards, alarms, and reports with interval-based metrics like:

  • Average irradiance

  • Total energy

  • Peak current


Examples

A Totalizer named KPI-IrradiancePOA is configured as follows:

  • Point Type: TOTALIZER

  • Aggregation: TimeAverage

  • Interval: 300 seconds (5 minutes)

  • Source Point (Raw from SCADA): @IrradiancePOA

  • SaveAtIntervalStart: True (to log the output timestamp at the beginning of the interval)

This setup calculates the average plane-of-array irradiance every 5 minutes — perfect for solar performance KPIs.

Example 5m average irradiance Totalizer

Totalizer Capability

Example Use Case

Syntax

Aggregate raw SCADA data over an interval of time

Compute average power over the last 5 minutes

TotalizerAggregate=TimeAverage | Interval=300 | SourceTag=@ActivePower

Compute maximum voltage in the last 5 minutes

TotalizerAggregate=Maximum | Interval=300 | SourceTag=@Voltage


Why Totalizers Matter

✔️ Simplified Analytics: No need for external tools to compute interval-based metrics.

✔️ Operational Insight: Capture trends like peak loads or average conditions over time.

✔️ Automation Ready: Feed alarms, reports, and dashboards with clean, interval-based data.

✔️ Flexible & Scalable: Apply to any raw point at the Edge, off-loading calculation resources from the central Bazefield servers.


Totalizer Aggregates

Full list of available totalizer aggregates:

  • COUNT

  • SUM

  • TOTAL

  • TIMEAVERAGE

  • INTERPOLATIVE_START

  • INTERPOLATIVE_END

  • AVERAGE

  • DELTA

  • MAXIMUM

  • MINIMUM

  • VARIANCE

  • STDEV

  • ANGAVERAGE

  • ANGTIMEAVERAGE