What is the calculation for determining the total volume produced within a designated timeframe in a value box?
How can I incorporate a value box calculation into our axiom application to track the volume produced by a specific production line over a 7-day period in our food and beverage industry?
How can I determine the total production output over a specified timeframe using the analog weight value measured in liters from a tank? Additionally, I have the option to utilize either a flowmeter or readings from weighted load cells as part of the active trends.
-
Hi rufus. reyneke ,
I would recommend two different aggregates. Maybe one of them will be the solution you need. The first is the Sum aggregate which simply adds up all raw values within the interval you are specifying. The second is a Total aggregate (and there are a few of these). The Total aggregates are typically used in conjunction with tags that are measuring some sort of rate (i.e. barrels per day, feet per second, etc). So if you're measuring something that is per hour, you would want to use the TotalPerHour aggregate. Essentially these aggregates first find the average through the entire interval, then multiply that value by however many hours/minutes/seconds/days are in that interval. This would give you an expected total based upon the average.
-
Steve Mason
Hi Steven,
I appreciate your prompt reply.
I'm optimistic that this solution will prove beneficial. I'll be conducting tests shortly to gauge its effectiveness. Currently, our focus lies in determining the volume flow via a flowmeter, crucial for tracking production trends on Axiom. Accurate measurements are pivotal for calculating batch outputs precisely. To achieve this, we're exploring totaliser calculations.
The batch total that we intend to produce is between 18,000 to 20,000 liters per batch. I would like to determine through the flowmeter a calculation from start to finish to see if we get to the targeted number.
Could you direct me to resources where I can delve deeper into aggregates and their practical application?
Best regards,
-
Steve Mason Hi Steve, this is what I am trying to achieve. In the live table I have my actual flowrate per hour as in actively live time. The shift start at 06:00am and ends at 18:00pm. I want to calculate the total volume that flowed through that flowmeter for the shift. Please assist or alternatively where I can learn more about Axiom aggregate tools and how to use them?
-
rufus. reyneke
Looking at your screenshot, you need to specify an AggregateInterval. Whenever using an aggregate, it must always be accompanied by an AggregateInterval. This should be 12hours (or 12h).
The AggregateStartTime is optional. If left blank, it will default to "Now-AggregateInterval", but you don't want that based upon your shift time. Instead you would use "6:00" or "d+6h". If you use "6:00", it will display the most recent interval that went from 6am-6pm up until it reaches 6am of the next day, at which point, it will start a new interval. If you use "d+6h", it will display the most recent 6am-6pm up until midnight, at which point, it will report a NoData until it reaches 6am of that day. So from midnight-6am, it would report NoData.
Most of the aggregates we use come from the OPC Foundation who defines them. You can visit https://reference.opcfoundation.org/Core/Part13/v104/docs/ for more details on them.
-
Print this page