[Imported] (Educated Trends) Generating trends based on IF and ELSE functions

[sbeadle]

>>Message imported from previous forum - Category:Scripts and Tips<<
User: ROVSCADAENGINEER, originally posted: 2019-01-18 02:51:00 Id:351
I am wanting to generate a trends page and or extrapolate data in a list form based on a series of IF and ELSE statements tied to the points. I am wondering if this is something that can be automated with the trends funcitonallity through building of pages in SCADA without using the bulk edit tool.

The application of this to put the question in context... is for the overflow floats on pump station sites. for instance if the pumps are running and the well level is giving a reading as low and has reliable consistent data to indicate that the overflow float ping may be a faulty ping, through IF statements I should be able to create and educated system which only flags reliable and definite overflows and then generates a report of faulty overflow pings. I want to run this for several sites so we can run bulk analysis. the trends page is ideal for this because you can specify time periods with historic data points. If anyone is aware of any methods in doing this or generating such a system The help would be highly appreciated!

Thanks in Advance!.

[sbeadle · Accepted solution]

>>Responses imported from previous forum

Reply From User: BevanWeiss, posted: 2019-01-21 20:27:09
Trends generally only work against historical values.
So the most straight forward way to do what you're asking is to have a Calculation Point in the background that is performing your If.. Else.. Endif type logic to generate a value to be pushed into the Calculation Point. Then you can trend this point.

Reply From User: ROVSCADAENGINEER, posted: 2019-01-30 23:51:07
[at]BevanWeiss said:
Trends generally only work against historical values.
So the most straight forward way to do what you're asking is to have a Calculation Point in the background that is performing your If.. Else.. Endif type logic to generate a value to be pushed into the Calculation Point. Then you can trend this point.

Thankyou Bevan! Great thinking!