Min and Max value of variable

4 Posts
3 Users
0 Likes
36 Views
(@r-miagkovarcinfo-com)
Posts: 30
Trusted Member
Topic starter
 

Hello,
i had request from customer.
He wants to know min and max value of variable certain period of time.

I know 2 ways.

1- via export trend. But this way doesn't suit the client. He wants to get this value in variable.
2 - via SQl requests, but he uses 11.2 version.

Do you know another way?

as required by the customer:
There is a trends (sample below) in the form of a process report.
On it, with the cursor, the user determines the start and stop of the process (the result is processed and visualized by the user in the form by pressing buttons 1 and 2)
The process time is calculated 3) by subtraction.
This is done.
It is not possible to automatically calculate and display in the MIN and MAX text the values of the graph variables for this process (visualization on the form, cells “trend 1, 2, 3….”).

 
Posted : 25/03/2021 5:06 pm
KASI
 KASI
(@k-simanjalamarcinfo-com)
Posts: 134
Estimable Member
 

Hello Roman,

Export Trend is not favorable, is it because they do not have Data Export feature in license?
If no restriction on license, I believe they can use GETSTATISTIC to retrieve max, and assign it to a variable. Of course the logic and assignment must be done from scada basic script.

Thanks,
Kantha

 
Posted : 25/03/2021 5:55 pm
(@r-miagkovarcinfo-com)
Posts: 30
Trusted Member
Topic starter
 

Hello Kantha,
he wants to make the report without exel, only in PcVue.

Thank's i will try

 
Posted : 25/03/2021 6:18 pm
n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hi Roman,
Kantha is not talking about Excel.
You can use the Export_Trend instruction with getstatistic mode to retrieve the data you want. This instruction fills up a buffer (not excel)
Then you can set pcvue variable.

Nico

 
Posted : 25/03/2021 7:02 pm