Energy Report

Energy Reports in Datacake enable automated, scheduled reporting of device consumption data. Reports are delivered via email and provide detailed energy consumption analysis across different time peri

Creating an Energy Report

  1. Navigate to the Reports section and click "Create Report"

  2. Select "Energy" as the Report Type

  3. Configure basic settings:

    • Report Name: Provide a descriptive name

    • Timezone: Select appropriate timezone

    • Schedule: Set execution time and days

Basic Settings

Report Configuration

Email Settings

  • Add recipient email addresses

  • Select email branding template if you have one or more White Label sites

Device Selection

  • Choose between:

    • Explicit: Select specific devices

    • Product: Include all devices from a product

Timeframe Options

Preset Timeframes

  • Last 7 days (bucketed by day)

  • Last 30 days (bucketed by week)

  • This month (bucketed by week)

  • This year (bucketed by month)

  • Custom range (configurable bucket width)

Custom Range Configuration

  • From: Start date (e.g., "7 days ago")

  • Until: End date (e.g., "now")

  • Bucket width: Day/Week/Month

Energy Report Settings

Understanding Time Bucketing

Time bucketing determines how data is aggregated in the report. Each bucket represents a time period with opening and closing values.

Example Data and Bucket Calculation

Sample Data

With monthly buckets, the Excel report generates:

January Sheet:

  • Open: 3 (First value in January)

  • Close: 12 (First value in February)

February Sheet:

  • Open: 12 (First value in February)

  • Close: 18 (First value in April, as March has no data)

March Sheet:

  • Open: 18 (Last known value)

  • Close: 18 (Next available value)

April Sheet:

  • Open: 18 (First value in April)

  • Close: N/A (Since no data newer than April exists)

Report Data

Bucket Calculation Rules

  1. Open Value = First value in bucket period

  2. Close Value = First value in next bucket period

  3. If no data exists in bucket, use next available value for both open/close

  4. Consumption = Close - Open

Time Bucketing Process

  1. Raw data points are collected

  2. Points are grouped by bucket width (day/week/month)

  3. Each bucket becomes a sheet in Excel

  4. Devices listed as rows in each sheet

  5. Open/close values calculated per bucket

  6. Consumption computed as difference between close and open

Last updated

Was this helpful?