Calculate Average Data and Get Minimum Values

abdullah123456789 · ‎2023-02-08

Hello,

I'm receiving datas in Geo SCADA. This datas are real time datas and saved to the database every 5 minutes as in the image below.

I need to take the average of this data recorded every 5 minutes and save it to the database hourly. Can I do this using the "calculation" feature? I did some things, but it recorded the average values in 5 minutes, not hourly. Did I make a wrong setting or is it not possible to calculate from here?

A second issue is that if I can save these data to the database hourly, I need to automatically select and specify the minimum 2 or 3 values in the next 24 data per day and create a trend list and specify these values in this trend. Is something like this possible? If possible how can I do it? Can you help me?

sbeadle · ‎2023-02-09

Your calculated point is updated on change of the input, so if the input changes every 5 minutes the output is calculated at that interval too - it will be a rolling hourly average.

Choose the Trigger Condition to be Periodic instead and set the interval to 1H, offset H

Alternatively use an Accumulator point, type 'Mean' and set it to report and reset hourly.

Accumulator points also have a 'Minimum' type which may solve your second question.

abdullah123456789 · ‎2023-02-09

I tried to pull the minimum or maximum data using the accumulator as you said, but I couldn't find any option to show more than one value in the trend. Can you help a little more with this? In addition, the data I received per hour from the maximum and minimum accumuators I created are as follows. I did not fully understand this data. Can you explain?

"Historic List" pages with a maximum on the top and a minimum on the bottom. Why are the values at the maximum and minimum the same here? Also, what is meant by the data coming in as current data?

abdullah123456789 · ‎2023-02-15

Thanks for the first topic. I can get the values as I want. But I'm still having problems with showing at least 3 values in the trend from the last 24 hours. I couldn't find anything on the help page either. Is there any solution to this situation?

sbeadle · ‎2023-02-17

What do you mean, top/bottom 3 values per day?

abdullah123456789 · ‎2023-02-20

I get data from RTU regularly and this data should be calculated hourly average and saved in the database hourly. For example, I have to calculate the value between 2-3 pm and save it to the database as the average value of 2 o'clock. I did this by making the following settings on the Calculation Tag. But when the settings are like this, the data is 2-5 A.M. It causes more than one value to be saved in the range. Actually, this is my first problem. I'm attaching a few screenshots of this situation below. The two above are images of the settings, and the one below is the Historic List image.

Thanks to the Historic List I created in this way, I was able to have a trend page. However, there was a problem with the trend. The hourly data in the trend list of the signal I created does not match the Historic List. Below I share the trend I created and some of the data in the trend with the images I marked with Ruler. I have already shared the Historic List of the same signal, belonging to the same days and times, above.

The other problem I'm having is as follows. That's what I really needed to learn. When I save this signal to the Historic List and view the trend page, I need to show only these minimum 3 data on the trend by first ordering the 24 data of a day I recorded on an hourly basis from the smallest to the largest, then filtering the data in the first 3 rows (minimum 3 data). I guess we could call it trend filtering.

These hourly data that I saved to the database are a total of 24 daily in the "historic list". I need to sort these 24 data from the smallest to the largest and then mark or specify the 3 data with the smallest value on the trend page I created. So in summary, I'm going to create a daily trend with the x-axis hourly. These values on the x-axis will include 0-23. There will be data every hour. The minimum of 3 values in this hourly data, which is shown in the trend, will be prominently displayed among other values. (a distinctive shape means circling, drawing those values in different colors, creating a text box over the points where the minimum values are)

I showed what I'm talking about by marking a minimum of 3 values in the image below.