Identify your peaks in DEXMA

Follow

In this article you're going to learn how to identify your peaks in the EMS Platform. 

Contents of this article:

  • Introduction
  • Punctual peaks
  • Accumulated data peaks

 

Introduction

Sometimes, you might find irregularities or “peaks” in your data that are the result of incorrect values sent by meters. These can be caused by single erroneous readings that can be eliminated using Delete Readings from a gateway, or they can be due to a change in a device's readings when there are accumulated readings. Both cases will be addressed in this article. Once you have identified your peaks, learn how to delete them

 

Identify Punctual peaks

This is the case where you have single readings that distort the analysis. Normally, the peaks are produced as a result of an erroneous value being sent by the meter. These spikes can be produced by mistake or after deleting a series of erroneous readings. 

To identify the time stamp where the spike occurs, you should go to any Analysis Screen an check the device consumption, such as the Consumption screen. In the screenshot below, the spike happens on the 1st of May.

Result:
dexma-peaks-01.png

Solution: Use delete readings to delete the wrong value. 

 

Identify Accumulated data peaks

Normally, meters in your facility are going to send the Energy data in a cumulative and incremental way, representing the consumption for a specific period of time. However, sometimes the datalogger might send outliers, causing peaks in the hourly curves and making the representation in the platform erroneous. For more information about Active Energy and its representation, click on the following support article: Understanding Active Energy

For this case, it is important to understand all the possible errors and how to solve them. These are the most habitual cases which cause peaks and how to deal with them:

  • Peaks caused by an outlier
  • Welcome peak
  • Negative jump on the Active Energy value
    • Case 1
    • Case 2
  • Positive jump on the Active Energy value
  • Increase or decrease of the Active Energy value

 

Peaks caused by an outlier

Sometimes, gateways installed can send some outliers which differs from the cumulated curve of the Active Energy. Lower or higher values can be received and cause a negative or positive peak on the EMS Platform graphs.  

 

 

04_f672c0f45306dcd182f3c338fc23a8264f64147ea53f1153298683d367f0edba.png05_4fb2156eb3ff50d2be8c1ba09d7d146b42c1be40c7df5e924ac1f7efd0312950.png

Result:

dexma-peaks-03.png

Solution: Delete the outlier on the Delete readings menu. As a reminder, the outlier must be deleted from the Active Energy parameter (402) not from the discrete values. 

 

Welcome peak

Probably your meters will start sending data with a value greater than 0, as it will be their cumulative value and most likely they were installed on the facility some time ago. That would cause a jump in the first reading. 

 

08_d5b574833a160babb20f58224974a6b507dfc840e02664ac24869aab593e206b.png

 

Result

dexma-peaks-04.png

Solution: In order to solve this welcome peak, you should "Recalculate" the "Active Energy" values. For that, you should go to Settings -> Parameters and recalculate the corresponding device from the date in which the peak has been found.

 

Negative jump on the Active Energy value: case 1

 

While inserting Active Energy values cumulatively, if a fiscal meter makes a reset (automatically or manually), it should start by 0 in order to avoid negative peaks. However, you might encounter some situations where the fiscal meter makes a reset or changes its value but doesn't start by 0.  
10_100cdb3690985861a92fea9fb159f989275f36ce0b70b73e4914ae0b9cbc008e.png
 

Result:

dexma-peaks-05.png

Solution: In this case, the best option is to treat existing data before the peak. So, you should modify the previous data from the peak and make coincide the last value before the peak with the first value after the peak. The steps you should follow are:
 

  • Download the Active Energy readings in Excel
  • Treat the data in order to avoid the peak. In the previous example, the best option is to divide the cumulated consumption into 2 smaller increments in order to match the values. In that case, the  curve look likes as follows:

12_4b83fa5225973d6a4991c8983b9042afb8736538960bc3368a1c285817712a7d.png

  • Delete the wrong readings 
  • Import new data on Excel using the EMS platform template. 

 

Negative jump on the Active Energy value - Case 2

Active Energy values must be cumulated. In the case that the fiscal meter makes a reset (automatically or manually), it should starts by 0 in order to avoid negative peaks.  We may encounter some situations where the fiscal meter makes a reset or change its value and don't start by 0 and still incrementing for a period of time and then makes a new reset.  

 13_1c0533bff39beb5b9d2c87569fc8367781ebb524773119e246edf573adfcb9e6.png

​ 

Result:

dexma-peaks-06.png

Solution: in this case, as we have a reset near the peak, solve this peak is easiest. What we have to do is to make start from 0 the data between the peak and the reset.  The steps we have to follow are the following: ​

  • Download Active Energy readings in Excel. 
  • Treat the data in order to avoid the peak. In the previous example, we will have to make the data set from 0 subtracting the jump value of the Active Energy to all the readings.        

15_e4d0fbaadd0524926a35d7b0316f9e390dd935fb0ce58bced8e44fc66da77032.png

  • Delete the wrong readings 
  • Import new data on Excel using the EMS platform template. 

 

Positive jump on the Active Energy value

Active Energy values must be cumulated. We can find that the fiscal meter sends cumulated data correctly, but suddenly it starts counting with a higher value and starts growing again from that value.

16_92a05e5acea2ec777db74434df40238740f3fd2784d363b5caa4506c7792585d.png

Result:

dexma-peaks-07.png

  

Solution: in this case, the best solution is to modify the data received before the peak. We will have to modify the data in order to make coincides the last value before the peak with the first reading after the peak. That means, try to put to the same height both series of data. The steps to follow are:  

  • Download Active Energy readings in Excel
  • Treat the data in order to avoid the peak. In the last example, we should take into account if we previously have data or not. 
    • If we don't have historical data, we just increment the values adding the "jump" value. Then, we will have to recalculate to avoid a "Welcome peak".   
    • In the case that we have historical data, we should create a new set of data which start from 0 using the previous values. That means, we will need to make start the curve many kWh behind as the value of the jump on the Active Energy.                                                      
  • Delete the wrong readings 
  • Import new data on Excel using the EMS platform template. 

 

Increase and decrease of the Active Energy value

In this case, the data starts growing but the values can slightly decrease (ex: for the meters that monitors both consumption and production of energy). This situation will produce negative values. 

20_057fea48740045e6a965fff0c5536cc12fcb30af251ec55dcaafddec6dce8312.png

Result:

dexma-peaks-08.png

Was this article helpful?