. . . but I don't want to count the time that part of the process is down / not in the running state. So the problem statement would be, "Last month, while FIC-101.pv was greater than 10.5, what percent of that time was FIC-202 in "AUTO"? Trying not to reinvent the wheel . . . TIA.

Hi John,

Thanks for posting on PI Square

This should be doable. To help provide you with the best solution possible. Can you provide some more information on how often you want the calculation to be performed. From the information, it appears that you want to calculate this every month? Is that correct or do you want a more frequent time period and calculate for the last month starting from when the calculation triggers?

Also, are you trying to historize this information (via a PI Tag) or do you just need the calculation in say Excel?

~Jesse