ValueSummary

Captures key values from a table into the frame.

This function performs simple analytic functions on some (or all) of the columns in a table and captures them.

This can be used to capture min, max, avg or total values across the different columns of your tables.

If you don't specify which columns the analytic should be performed on, it will be applied to all columns.

If the frame contains the following table…

{
   "type": "valuesummary",
    "method": "avg"
}

Your frame would then contain…

If your values represent a rate (such as an amount of production per minute), you can use the two special parameters ('rate' and 'timebase') to change how the analytics are performed.

The first is rate, which should be the name of the column where the speed or flow rate of your process can be read.

The next is timebase, which lets specify the number of seconds that each 'rate' measurement represents. For example, this would be '60' if your rate measurement is in units-per-minute, or 3600 if it's in units-per-hour.

So - for example - if you have scale giving you weight per meter and a sensor giving you meters per minute, you could use the following configuration…

{
   "type": "valuesummary",
   "columns": ["Scale.Weight"],
   "rate": "Line.Speed",
   "multiplier": 60,
   "mode": "total"
}

…which would give you a “Total Scale.Weight” figure that contained the total weight of manufactured product.

In some cases, you might want several different summary values.

{
   "type": "valuesummary",
    "method": "avg",
   "split": "Product"
}

Your frame would then contain…