Delete peaks in DEXMA


In this article you're going to learn how to delete peaks on the EMS platform. 

Content of this article: 


Manual readings

This app can be used to remove peaks due to a big change in cumulated readings, such as a meter change. Learn more about Manual Readings app

If your meter has basic cumulated data, and there is a big change in the readings which is maintained (this usually happens when utilities change meters), the readings cannot be eliminated as a single peak (just deleting one reading) since the peak would slide in time. In this case, the consumption for the period in which the reading jumps must be set to a constant value (such as 0) so that the peak does no longer appear.

For this, you should first identify the approximate period in which the peak occurs through a graph in the consumption screen:

To identify the exact moment when the peak occurs, you must follow the following steps:

  • Go to the "Settings" menu and access the "Gateways" section.
    Go to the "Delete Readings" tab


In this example, the peak occurs between 7:00 and 07:15 on 19/11/2018.

The readings that must be corrected are therefore the ones that correspond to the value before the peak, 19/11/2018 07:00. Taking note of this moment you can set the consumption reading to 0 for each frequency for which you need to perform analysis through the app.

Following the steps described in this article about the Manual Readings app, the corresponding gateway is configured.  

Once the gateway is configured as required by the application, you can select the location and the parameter and you can insert readings with 0 value for each frequency (Quarterly: 15 minutes, Half hour: 30 minutes, Hourly: Hours, etc. ...) as seen in this caption:

Once the reading is imported, if you wait for about 5 minutes, the peak for that frequency in the consumption graph will have disappeared. In the example, the quarter-hour frequency has been used. The process must be repeated for each frequency that is causing problems.



Delete readings

Once you have identified the peak, the type and the time, you can delete it through the Delete readings tab. Learn more about delete readings

In order to delete a single peak follow this steps: 

1. Identify the peak  and the gateway that contains the device.

2. Go to gateways -> Delete readings 

3. Select the parameter and input the dates that contain the timestamp where the peak occurs and review the readings.


4. Select any wrong readings that appear and click on "Delete". The spike should disappear from your chart after a short delay. If it is not the case, try manually recalculating the device for the period there the spikes happened.

Note: This procedure works for single peaks from discrete readings.When the wrong value happens once. When you delete the reading the spike is corrected. 


Data insertion

There are some cases where data must be restored and reinserted again in the platform to avoid the peaks. This can be do in to ways through excel or through our open API. Learn more about Importing data to the EMS platform. This is the list of cases where is necessary to import data to delete peaks: 

In order to restore this kind of peaks you should follow this steps:

  • Download the Active Energy readings in Excel
  • Treat the data in order to avoid the peak. 
  • Delete the wrong readings 
  • Import new data on Excel using the EMS platform template or inserting the new values through the API. 




Was this article helpful?