Datacake Docs
  • Welcome
  • Get Started
  • Changelog
  • Best practices
    • Best practices: Getting started
    • Best practices: Resolution (Timeframe)
    • Best practices: Dashboards
    • Best practices: Reports
    • Best practices: Grouping Devices
  • Datacake LNS
    • Getting Started
    • Gateways
      • Milesight LoRaWAN Gateway - UG6x
      • RAKwireless WisGate Edge Light 2
    • Devices
    • Add Devices without Gateway
  • Device
    • Product
    • Configuration
    • Claiming
    • Historical Data
    • Database
      • Configuration Fields
      • Fields
        • Manual input
        • Field Roles
        • Formulas
        • Mapping Fields
      • Data retention & Datapoints
      • Examples
        • Mapping 4-20mA Signals
        • Converting Units
  • Dashboards
    • Global Dashboards
      • Setting Homepage
    • Device Dashboards
    • Multi-Device Dashboards
    • Widgets
      • Value Widget
      • Chart Widget
      • Image Map
      • Map Widget
      • Text Widget
      • SOS Widget
      • Boolean Widget
      • iFrame Widget
      • Downlink Widget
      • Set Value Widget
      • Measurement List Widget
      • Heatmap Widget
      • Table Widget
      • Image Widget
  • Portal
    • Multi-Tenancy (Workspaces)
    • Reports
      • Energy Report
    • Administrators
    • Members
      • API Users
    • Security & Privacy
    • Billing
      • Support Packages
      • VAT Exemption / Tax ID
      • SMS Credits
      • Access Invoices
      • Unused time and Remaining time in Invoices (Prorations)
      • Codes
    • White Label
    • Rules
      • Legacy Rule Engine
        • Sending notifications via Telegram
      • New Rule Engine
        • Rule Engine Table Overview
        • Copy/Paste and Template Functionality
        • Advanced Rule Engine E-Mail and Webhook Templates
        • Time Restrictions
    • Zones
  • Cake Red
    • Get Started
    • Overview
  • LoRaWAN
    • Get Started
      • CSV Import
      • Custom LoRaWAN Device
    • Configuring LNS
      • The Things Stack (TTN / TTI) Automated Setup
      • The Things Stack (TTN / TTI) Manual Setup
      • Loriot
      • Kerlink Wanesy
      • Helium
      • ChirpStack
      • Tektelic
      • Actility ThingPark
      • Senet
      • Milesight Gateway
      • KPN
    • Downlinks (LoRaWAN)
      • Set Time Frame
    • Securing Webhooks
    • Payload Decoders
      • Location and GPS
      • Access Gateway Metadata
      • Access Measurements
      • Global Variables
    • Using Cayenne LPP
    • Converting Payload
  • Generic API Devices
    • HTTP Downlinks
  • Integrations
    • MQTT
    • Particle
      • Get Started
      • Adding Integrations
      • Decoding Payloads
      • Calling Functions
      • Templates
        • Particle Tracker One
    • Incoming Webhooks
    • Outgoing Webhooks
      • Securing Outgoing Webhooks in Datacake
    • Golioth
    • Blues Wireless Notecard
    • Sigfox
    • Swarm Asset Tracker
    • Grandcentrix Modbus Cloud Connect
    • YuDash LYNX IoT Gateway
    • Dragino NB-IoT
      • Changing NB-IoT Bands
    • Hardwario CHESTER
    • 1NCE OS
  • API
    • Exporting Data
    • Record Measurements via API
    • Node RED to Datacake
    • Generate Access Token
    • Internal MQTT
      • Get Started
      • MQTT Documentation
      • MQTT over WebSocket
      • Example Code
    • GraphQL API
      • Using GraphQL
      • Device Creation
      • Tutorials
        • Read Group via Tags
  • Guides
    • Python
    • Send Slack Notifications
    • Forward Data to Cake Red
    • Multiple Data Feeds
    • Automated Dynamic Downlinks
    • Ingesting JSON Data into Datacake API Devices
    • Working with Default HTTP Decoder on API Devices and Code Examples
    • Accessing Measurements in Decoders
    • Connecting Datacake to Notion Using Zapier
    • How to set up and use location on non-GPS devices
    • How to integrate with AWS IoT Core
    • How to Schedule Mass-Downlinks (Multicast) using Datacake Rule Engine
    • How to Map Sensor Values to Ranges or Booleans, Strings using Mapping Fields
    • Understanding Internal vs. External MQTT Brokers on Datacake
    • Sending UDP Messages between 1NCE OS and Datacake
    • Concepts of LoRaWAN Payload Decoders on Datacake
    • How to check if a value stays above or below limits for given time
Powered by GitBook
On this page
  • Creating an Energy Report
  • Report Configuration
  • Understanding Time Bucketing

Was this helpful?

  1. Portal
  2. Reports

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

Last updated 3 months ago

Was this helpful?

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

Report Configuration

Email Settings

  • Add recipient email addresses

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

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

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)

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

Select email branding template if you have one or more

White Label sites
Basic Settings
Energy Report Settings
Sample Data
Report Data