Selmane

Hello Pat, indeed step two is where you didn't find the corspondance between Excel and Seeq. The Signal from condition you did will compute an average for every high efficiency capsule. In order to compute the average on all capsules, I suggest the following steps: Create a new "cleansed" temperature signal which equals to nothing outside the high quality periods and equals to temperature during those periods. This is equivalent to the filter you put on Column E. This formula should do the job: $temperaturesignal.remove($highqualitycondition) Create a new condition by merging the high quality capsules. This way, you will have a long period of time coverting all temprature samples. This formula should do the job as well: $highqualitycondition.merge(2d). Please replace the 2d by the maximum interval between your capsules) Now you can calculte the average and standard deviation of the new created signal during the new condition. Please pay attention to maximum capsule duration field in the Signal From Condition tool Now you are all set, you can calculate the upper and lower limits with simple Formulas and you should obtain something similar to the below screenshot: Let me know if this works for you or not. Thanks, --Selmane

Hello Christian, Since R59, we have introduced Organizer Templates which simplifies report creation across the organization. But if my understading is corret, your idea is to have multiple pages with the same header and footer as in PowerPoint or Word. This functioannality doesn't exist yet in Seeq Organizer but can you: Provide the process for creating this kind of reports? What is your current Seeq version? Thanks, Selmane

Hello Jessica, You can use the Formula tool to transform any signal to continuous (tolinear()), discrete (todiscrete()) and step (tostep()). You also need to be careful about the max interpolation period between samples. You can add that parameter as an argument in the formula. For example: $temp.tolinear(24h). Can you please test these formulas and let me know if this works. Have a good day, Selmane

Hello Yanmin, Do you want to replace the blank or just visually see that in the trend? If the latter, in the Import CSV tool, you can use "Step" in Interpolation method if the signal is step interpolated. Also, make sure you use the right amount of hours in the Max Interpolation. In your case, 48h should be sufficient. Is this what you were looking for? --Selmane

Hello Nate, Is this a PI tag or an AF Formula? Can you show tag configuration, PI Vision or PI SMT screenshot + Workbook screenshot? And why is the data overwritten frequently? Is it a Manual Tag? --Selmane

Hello Wouter, well, it is not possible to create a condition from a table. I have captured that as a feature request internally, it could be a good idea to have that. Nevetheless, it is possible to use formula to achieve a similar result using Keep Formula: $condition.keep('state', isEqualTo('A')) where: $condition is the current condition with all properties ‘state’ is the name of the property 'A' is the property itself and that you want to keep I hope this is helpful, --Selmane