Creating a rolling average with infinitii flowworks advanced calculation engine

The infinitii flowworks advanced calculation engine (face) empowers users with data manipulation tools, allowing them to create and define new datasets from incoming raw channels, using advanced math, statistics and logic equations.

With infinitii face, you can create, edit, delete and combine data channels with powerful mathematical functions for sophisticated real-time analysis.

Rolling Average is one of the many functions available to you in infinitii face. Rolling averages can be used to smooth out data when the sampling interval is frequent or to create values for comparison if you want to view the relationship between two raw data channels with different sampling intervals.

infinitii ai learning series video on creating a rolling average with infinitii face

Click on the video image above and you will learn how to create a one-hour rolling average rain channel from a main rainfall data channel. These are the steps:

• Log into infinitii flowworks

• Select the site you are interested in to view its data

• Select Graphing to access the flowworks Graphing Feature

• Select the Rainfall Channel

• Select the date range to view Rainfall data

• Select Plot Data

• Navigate to Manage>> Configure Sites (FACE)

• Select a site to add

• Click add new channel

• Name the channel and select the measurement units. For channel type select "calculated". Be sure the visible attribute is checked if you want to share this channel with other flowworks users.

• Once the channel is created select it from the "choose calculated channel" drop down box.

• Click "View calculated channel" then "Add calculation"

• In the "Type" drop down box, select "Rolling Average". You can select a date range to apply this calculate to or just leave blank to apply the calculation to all data + any new data that is received from the underlying channel

• Choose a source channel.  Here, we want the Rainfall channel.

• Select the time interval you want to average, the step size or how many data points should be created in the interval and a fail value for any instances where the underlying data cannot return a value.

• You have the option when creating this kind of calculation to copy it to other sites that have a channel with the same name and the same underlying source channels to create the calculation. This can save you a lot of time when setting up calculations.

• Click save, and infinitii flowworks goes to work creating new values for the new channel

• Once the calculations are completed, go back to the Graphing feature to view the results.

• In Graphing, select Rainfall and your new one hour rolling average channel to graph, then select Plot Data to view the results.

Thats it. You now have a new rolling average channel for rainfall that can be used in your analysis and reports.  The results provide a different way of viewing the data and can be used as building blocks for more complex calculations.  Give it a try!