AnsweredAssumed Answered

Averaging data from specific time periods each day

Question asked by adam.marshall on Jun 24, 2019
Latest reply on Jun 24, 2019 by rdavin

Is it possible in AF Analysis to get a an averaged value for a tag where you need to select a period each day for each weekday for a rolling historical period? I can do it (with multiple stages) in PI Datalink and using excel, but I need a way to calculate this within AF.

 

Eg. For a tag, determine the average value for the periods (00:00 to 01:59, 02:00 to 03:59, etc) if the day is a weekday (Monday - Friday) over the previous 30 days. This results in 12 period averages.

This will also determine  the average value for the periods (00:00 to 01:59, 02:00 to 03:59, etc) for every Saturday & Sunday) over the previous 30 days.This results in 12 period averages.

 

PI AF Server 2.8.5.7759

PI AF SDK v 2.8.6.7801

 

 

Outcomes