General Discussions
How to average a selectable graph in HDV?

I need to average one point on the graph to another, without exporting all the recorded content, only the selectable content. And I need to export it via Excel. How do I do this? Is there a method?

68b2f31e42038

I need to average just this one pen that is circled:

I need to average one point on the graph to another, without exporting all the recorded content, only the selectable content. And I need to export it via Excel. How do I do this? Is there a method? ![68b2f31e42038](serve/attachment&path=68b2f31e42038) I need to average just this one pen that is circled:
edited 5 days ago at 2:27 pm

You could used a History Statisitcs Tag, or script a filter - see links below:

https://www.vtscada.com/help/Content/D_Tags/Dev_HistoryStats.htm

https://www.vtscada.com/help/Content/Scripting/Tasks/FirstOrderFilter.htm?tocpath=Scripting%7CExamples%20and%20How-To%27s%20for%20Scripting%7CScript%20Code%20Examples%7C_____3

You could used a History Statisitcs Tag, or script a filter - see links below: https://www.vtscada.com/help/Content/D_Tags/Dev_HistoryStats.htm https://www.vtscada.com/help/Content/Scripting/Tasks/FirstOrderFilter.htm?tocpath=Scripting%7CExamples%20and%20How-To%27s%20for%20Scripting%7CScript%20Code%20Examples%7C_____3

So, let's go... I need the average to be cyclical. I noticed that this "Historical Statistics" tag calculates the average of the entire variable. It's like going from "point A" to "point B" = average (A and B). Then, it will present another cycle... "point C" to "point D," and so on.

The value of this average will be generated by Excel. I'll take some random numbers as an example, so you can visualize.

Cycle 1 (red) = Average (15, 20, 30, 10) = 18.75

No values ​​(values ​​zero and less than 0 do not appear).
indicated in gray.

Cycle 2 (green) = Average (12, 75, 36, and 23) = 36.5

No values ​​(values ​​zero and less than 0 do not appear) - indicated in gray.

And so on.

And at the end of each cycle, calculate its average. When it reaches 0 or less, it indicates a new cycle.

I'm racking my brain for a solution.

68b63a3ba09cd

So, let's go... I need the average to be cyclical. I noticed that this "Historical Statistics" tag calculates the average of the entire variable. It's like going from "point A" to "point B" = average (A and B). Then, it will present another cycle... "point C" to "point D," and so on. The value of this average will be generated by Excel. I'll take some random numbers as an example, so you can visualize. Cycle 1 (red) = Average (15, 20, 30, 10) = 18.75 No values ​​(values ​​zero and less than 0 do not appear). indicated in gray. Cycle 2 (green) = Average (12, 75, 36, and 23) = 36.5 No values ​​(values ​​zero and less than 0 do not appear) - indicated in gray. And so on. And at the end of each cycle, calculate its average. When it reaches 0 or less, it indicates a new cycle. I'm racking my brain for a solution. ![68b63a3ba09cd](serve/attachment&path=68b63a3ba09cd)
edited 2 days ago at 1:28 am

Note: it is just one variable that is in this cycle. It presents values ​​above 0...and does not present values ​​below zero (negative) and equal to zero (invalid);

Note: it is just one variable that is in this cycle. It presents values ​​above 0...and does not present values ​​below zero (negative) and equal to zero (invalid);
59
3
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft