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).