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

Sometimes we find irregularities, or “peaks” in our data that are the result of incorrect values sent by meters. These can be caused by single erroneous reading that we can eliminate using Delete Readings from a gateway, or they can be due to a change in a reading in the counter, when we have accumulated readings. We will address each case here. Once you have identified your peaks learn how to delete them here

 

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. This spikes can be produced by mistake or after deleting a series of erroneous readings. 

To identify the time stamp where the spike occurs 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, analyzers we have installed in our facility or the fiscal meters, are going to send the Energy data in a cumulative and incremental way, representing how much we have consumed for a specific period of time. Although, we can obtain from the datalogger some 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 that, we should understand all the possible errors and how to solve them. Then, we are going to explain the most habitual cases which cause peaks and how to deal with them:

 

Peaks caused by an outlier

Sometimes, gateways installed can send some outliers which differs from the cumulated curve of the Active Energy. We can receive a lower or higher value 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. We remind that we must delete the outlier on the Active Energy parameter (402) not from the discrete values. 

 

Welcome peak

Probably our meters start sending data with some cumulative value and don't start sending from 0, because they were installed on the facility some time ago. That should cause a jump in the first reading. 

 

08_d5b574833a160babb20f58224974a6b507dfc840e02664ac24869aab593e206b.png

 

Result

dexma-peaks-04.png

Solution: In order to solve this welcome peak, we just have to "Recalculate" the "Active Energy" values. For that, we go to Settings -> Parameters and recalculate the corresponding device from the date we have found the peak.

 

Negative jump on the Active Energy value: case 1

 

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 after that value.  
10_100cdb3690985861a92fea9fb159f989275f36ce0b70b73e4914ae0b9cbc008e.png
 

Result:

dexma-peaks-05.png

Solution: in this case, the best option is to treat existing data before the peak. So, we will have to modify the previous data from the peak and make coincides the last value before the peak with the first value after the peak. The steps we have to follow are the following: 
 

  • 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".   18_4fdfd728638cddeceafc6dbe1e86dc9b7025468e78a4d81d231477165cc8cd72.png
    • 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.       19_132231578fa0ec80eccc5314386ac348e586da85c20a5a3bba21df698550bf87.png                                               
  • 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?