====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|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**.

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

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

===Calculating Per-Product Totals===

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

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


Your final capture would contain something like the results below...

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