Calculating a Total

If you have some form of rate value (such as a flow rate, power consumption etc), you can capture the total amount using the ValueSummary layer.

In the example below, we're going to total a column named Water Main.Flow Rate.

This rate is in litres-per-minute and we want our resulting value in kiloliters.

{
   "rate": "Water Main.Flow Rate",
   "values": ["total"],
   "named": ["Total Water Used"],
   "timebase": 60,
   "multiplier": 0.001
}

To break it down, we're looking for the value total based on the rate Water Main.Flow Rate. Each unit of flow represents 60 seconds (1 minute).

Your final capture would contain something like the results below…

Total Water Used: 125 (Kl).

You can also choose to split your totals into sub-totals.

For example, lets say you have a Production Line.Product Type property, and you'd like to see total water usage per product type.

You can use the following…

{
   "rate": "Water Main.Flow Rate",
   "values": ["total"],
   "named": ["Total Water Used"],
   "timebase": 60,
   "multiplier": 0.001,
   "splitby": "Production Line.Product Type"
}

Your final capture would contain something like the results below…

Product A Total Water Used: 25 (Kl). Product B Total Water Used: 100 (Kl).