AnsweredAssumed Answered

How to implement a 30 day rolling average in analysis services using boiler operating days (special criteria to decide whether or not to include a day)

Question asked by Robert Raesemann on Mar 5, 2017
Latest reply on Mar 8, 2017 by Robert Raesemann

I need to setup an AF Analysis to calculate a 30 day rolling average of a boiler's NOx. The tricky part is that I need to use 30 boiler operating days, not 30 calendar days. A boiler operating day is any day where the boiler ran for 24 hours straight. If the boiler is offline for any period during that day, it does not get used in the average. I need to look back as many days as required to find 30 boiler operating days and then calculate an average NOx reading for each day and then average the 30 daily readings. I'm not sure if this is even possible given the current capabilities, but I figured that if it is, someone will have a good trick.