AnsweredAssumed Answered

How can I convert a PIAdvCalcFilVal into an SQL Query

Question asked by Mark.Andrews on Mar 10, 2017
Latest reply on Mar 13, 2017 by kduffy

I wish to convert various datalink queries into a SQL queries for reporting. Can anyone help?

 

=ROUND((PIAdvCalcFilVal('Dig33'!$B$14,'Dig33'!$F$3,'Dig33'!$F$2,'Dig33'!$A$14,"count","time-weighted","compressed","10m",0,1,0,"")/60/PIAdvCalcFilVal('Dig33'!$B$14,'Dig33'!$F$3,'Dig33'!$F$2,'Dig33'!$A$14,"count","event-weighted","compressed","10m",0,1,0,"")),0), =ROUND((PIAdvCalcFilVal('Dig33'!$B$14,'Dig33'!$F$3,'Dig33'!$F$2,'Dig33'!$A$14,"count","time-weighted","compressed","10m",0,1,0,"")/60/PIAdvCalcFilVal('Dig33'!$B$14,'Dig33'!$F$3,'Dig33'!$F$2,'Dig33'!$A$14,"count","event-weighted","compressed","10m",0,1,0,"")),0)

 

=ROUND(PITimeFilter('Dig31'!$A$14,'Dig31'!$F$3,'Dig31'!$F$2,"1d","minutes",0,"zarvls45")/F33,0)

Outcomes