---
title: How NULL values are handled for Electricity
description: Learn why missing values occur in Power and Power Quality data and how the platform handles NULL and 0 values per device type and dashboard.
---

[Skip to content](https://support.sensorfact.eu/knowledge/how-null-values-are-handled-for-electricity#main-content)

- [English](https://support.sensorfact.eu/knowledge/how-null-values-are-handled-for-electricity)
- [Deutsch](https://support.sensorfact.eu/de/knowledge/how-null-values-are-handled-for-electricity)
- [Español](https://support.sensorfact.eu/es/knowledge/how-null-values-are-handled-for-electricity)
- [Français](https://support.sensorfact.eu/fr/knowledge/how-null-values-are-handled-for-electricity)
- [Italiano](https://support.sensorfact.eu/it/knowledge/how-null-values-are-handled-for-electricity)
- [Polski](https://support.sensorfact.eu/pl/knowledge/how-null-values-are-handled-for-electricity)

English

Show submenu for translations

![sensorfact\_new\_logo](https://support.sensorfact.eu/hubfs/00.%20Archive/sensorfact_new_logo.svg)

Open main navigation

Close main navigation

- - [English](https://support.sensorfact.eu/knowledge/how-null-values-are-handled-for-electricity)
    - [Deutsch](https://support.sensorfact.eu/de/knowledge/how-null-values-are-handled-for-electricity)
    - [Español](https://support.sensorfact.eu/es/knowledge/how-null-values-are-handled-for-electricity)
    - [Français](https://support.sensorfact.eu/fr/knowledge/how-null-values-are-handled-for-electricity)
    - [Italiano](https://support.sensorfact.eu/it/knowledge/how-null-values-are-handled-for-electricity)
    - [Polski](https://support.sensorfact.eu/pl/knowledge/how-null-values-are-handled-for-electricity)

  English
  
  Show submenu for translations
- [Go to Best Practices Hub](https://support.sensorfact.eu/resource-hub)

[Go to Best Practices Hub](https://support.sensorfact.eu/resource-hub?hsLang=en)

 What are you looking for?

- There are no suggestions because the search field is empty.

1. [Help Center](https://support.sensorfact.eu/knowledge?hsLang=en)
2. [Dashboard & Insights](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en)
3. [Energy management](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#energy-management)

# How NULL values are handled for Electricity

## Missing values in Power and Power Quality data can result from bridge/gateway disconnections, device disconnections, unsupported metrics, or devices returning NULL values. Handling depends on the device type: devices that cannot distinguish between NULL and 0 convert missing values to 0, while devices that can distinguish between them show NULL as missing data (Power Quality Dashboard) or convert it to 0 (Power Dashboard).

### Missing value handling for Power & Power Quality

#### When Can Missing Values Occur?

Missing values can occur in the following 5 situations:

**1. Sensor skipped a measurement**

Most sensors and meters transmit a measurement approximately every 30 seconds. However, occasional delays can occur. If a delay exceeds one minute, no measurement may be recorded for that entire minute. Since the web app displays data at a one-minute granularity, this can result in a missing data point for that interval. You would have to zoom in to see these skipped measurements.

**2. Bridge/Gateway Disconnection**

If the bridge or gateway that transmits data from the device disconnects, no data is received by the platform.

To verify this:

- Open the **Status** page via the button in the top-right corner of the Sensorfact web app.
- Navigate to the **Bridge/Gateways** tab.
- Check the **Last seen** timestamp to see when the latest update was received.

**3. Device Disconnection**

If an individual sensor or device disconnects, it will stop sending data.

To verify this:

- Open the **Status** page.
- Navigate to the **Sensors** tab.
- Check the connectivity status of the device.

**4. Device Returns NULL or Unknown Values**

A device may remain connected but return NULL or unknown values.  
In this case, the platform continues receiving data, but some measurements contain NULL values.

**5. Metric** **Not Supported by the Device**

Some devices measure only a subset of available power quality metrics.

For example:  
If a device measures voltage, current, and power, but not power factor, the power factor field will contain missing values.

#### How Are Missing Values Handled?

Handling of missing values depends on the device type and whether the system can distinguish between **NULL** and **zero (0)** values.

**Devices That Cannot Distinguish Between NULL and 0**

*Example: Current clamps*

Current clamps rely on measured current to operate.  
If no current is measured, the device cannot send data.

In this case:

- NULL or missing values are transformed into **0** in the platform.
- No distinction is made between NULL and zero.

**Devices That Can Distinguish Between NULL and 0**

*Example: Power meters*

Power meters can transmit explicit 0 values because they do not depend on measured current to operate.

Handling differs per dashboard:

*Power Dashboard*

- All NULL values are transformed into **0**.

 

*Power Quality Dashboard*

- A distinction is made between NULL and 0:  
    - **NULL values** are displayed as missing data (trend lines are broken).

- - **0 values** are displayed as 0.

If for the selected devices there is only missing data for the selected timeframe, the platform provides a general no data statement as follows:

- [Hardware & Installation](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#main-content)

    - [Energy Management](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#energy-management)
    - [Gas Management](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#gas-management)
    - [Predictive Maintenance](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#predictive-maintenance)
    - [Water Management](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#water-management)
    - [Compressed Air Management](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#compressed-air-management)
    - [OEE](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#oee)
    - [Temperature & Humidity](https://support.sensorfact.eu/knowledge/hardware-installation?hsLang=en#temperature-humidity)
- [Dashboard & Insights](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#main-content)

    - [Energy management](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#energy-management)
    - [Compressed Air](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#compressed-air)
    - [Overall Equipment Effectiveness (OEE)](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#overall-equipment-effectiveness-oee)
    - [Reports](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#reports)
    - [Alerts](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#alerts)
    - [Ultrasonic Water](https://support.sensorfact.eu/knowledge/dashboard-insights?hsLang=en#ultrasonic-water)
- [Advice & ROI](https://support.sensorfact.eu/knowledge/advice-roi?hsLang=en#main-content)

    - [Energy Management](https://support.sensorfact.eu/knowledge/advice-roi?hsLang=en#energy-management)
    - [Predictive Maintenance](https://support.sensorfact.eu/knowledge/advice-roi?hsLang=en#predictive-maintenance)
    - [Compressed Air Management](https://support.sensorfact.eu/knowledge/advice-roi?hsLang=en#compressed-air-management)
- [Account & Billing](https://support.sensorfact.eu/knowledge/account-billing?hsLang=en)
- [Troubleshooting](https://support.sensorfact.eu/knowledge/troubleshooting?hsLang=en#main-content)

    - [Energy Management](https://support.sensorfact.eu/knowledge/troubleshooting?hsLang=en#energy-management)
    - [Gas / water pulse Management](https://support.sensorfact.eu/knowledge/troubleshooting?hsLang=en#gas-water-pulse-management)
    - [Ultasonic Water Management](https://support.sensorfact.eu/knowledge/troubleshooting?hsLang=en#ultasonic-water-management)
- [Product Updates](https://support.sensorfact.eu/knowledge/product-updates?hsLang=en#main-content)

    - [Release Notes 2025](https://support.sensorfact.eu/knowledge/product-updates?hsLang=en#release-notes-2025)
    - [Release Notes 2024](https://support.sensorfact.eu/knowledge/product-updates?hsLang=en#release-notes-2024)

[![sensorfact\_new\_logo](https://support.sensorfact.eu/hubfs/00.%20Archive/sensorfact_new_logo.svg "sensorfact_new_logo")](https://www.sensorfact.eu)

Copyright © 2026, Sensorfact