Can you give some recommendation for me to learn "time filtered" menu in PI Datalink? I already seen the tutorial in youtube but nothing helps.
Please feel free to ask your question here!
With this function, you are asking for 'Time' to your Yes/No question. For your configuration above to work, my guess is similar to below:
- Root path : \\PIMS\heat rate\Air data- Expression for example: ''Air temperature at inlet of AH/Reference temperature' > 1.5
( Enter two single apostrophes in the cell. Excel will hide one apostrophe from the view but will recognize that it's a text type data. The second apostrophe and the last one at the end are a PI DataLink syntax to indicate that it is a name of attribute like 'sinusoid')
Your expression should always be in form of Yes/No question. Given the start and end time, the function returns the time duration.
So in order for above attribute to work, it needs to be either
- Result as 1 or 0
- True or False
- Or add numbers so to find if my 'Temperature' larger than 35? ('Temp'>35, Yes/no?)
I hope this helps!
Thanks for answer Jin
I have try and I get it, any solutions?
It says that your expression is not right.
Try to make it look as below and set Experssion to below cell:
'Air temperature at inlet of AH/Reference temperature'>1.5
It is one attribute, could you confirm? I put 1.5 for a test. Please change the expression to suit your need.
I try to change the attribute, but still error. do you know why?
(Correction) Please try changing the cell type for B3 from texts to general.Another thing is that since your end results will be an array so it may erase B11~ B14. Please copy the results from below and paste elsewhere or move the output cell to other columns.
Take a look at the help menu within Excel PI Datalink. It explains "Expressions in Excel cells" and "Cell references in expressions"
Expressions in Excel cells
Big thanks Bruce
Retrieving data ...