Can you clarify if your use case has 1 output PI Point or multiple PI Point(s)?
Is there any reason why you are not using RDBMS interface to bring your table data into the PI System? That would remove a lot of complexity and greatly improve performance.DevenPatel supported this idea ·
An error occurred while saving the commentDevenPatel commented
I want to create the attached graph in PI Vision. The red and blue lines are coming from Pi Tags. The green line is a calculated line with the logic as given below.
1) get the reference date from "COM3 NPL DATE" PI Tag
2) if the reference date is null then and
if today is monday then
set the reference date as 3 days prior to Today's date
else if today is saturday then
set the reference date as 6 days prior to Today's date
set the reference date as Yesterday's date
3) get the points from "COMPUTER NET POWER FOR LOAD" PI Tag into a New PI Tag called "COM3 NET POWER FOR LOAD"
For step 1 & 2, I can get the value in the Reference Date variable
For step 3, I can use the following InterpolatedValues('SensorX','ReferenceDate -1','ReferenceDate','+1m') function. But I want to store the values of this function back to an output attribute and to a Pi Tag which I can use it in PI Vision along with other tags.