wiki:total
Table of Contents
TOTAL() Function
The TOTAL() function sums up all values for a variable and given period
Usage:
VALUE(variable, options)
variable - the variable name to check
options - see below
Generic Variables (per device type)
TOTAL('solar_watts',1)/60000
Get the sum of the solar_watts for the entire day (minute by minute) and divide by 60000 to get the Kilowatt Hour value
Device - Specific Variables
For device specific variables use a . to separate the device name:
TOTAL('My Device.My Value',1)
Option Parameters
The second parameter, [options] is a number and can be any of the following
| 0 | Latest value |
| 1 | DAY - Sum of all data points for the variable during the day |
| 2 | WEEK - Sum of all data points for variable during the week |
| 3 | MONTH - Sum of all data points for the variable during the month |
| 4 | YEAR - Sum of all data points for the variable during the current year |
| 5 | PERIOD - Sum of all data points for the variable during the selected range |
| 6 | SLICE - Sum of all data points for the variable during the slice in the range (i.e. in a graph segment) |
Example
Get the sum for the variable data points today
TOTAL('delta0w_ac',1)
wiki/total.txt · Last modified: 2017/05/08 10:29 by admin
