Navigation :
Language
Platform
Library
Reference
- Glossary
- List of read options
- List of operators
- List of aggregators
- List of functions
- List of keywords
- Tile syntax
- List of tiles
- List of icons
- List of virtual tables
- Convolution power
- StyleCode sub-language
-
_
-
A-B-C
-- abs
-- actionrwd.demand
-- actionrwd.reward
-- actionrwd.segment
-- all
-- and
-- any
-- areSame
-- argFirst
-- argLast
-- argmax
-- argmin
-- argRound
-- assoc.quantity
-- avg
-- canonical
-- cdf
-- ceiling
-- chineseYear
-- chineseYearEnd
-- chineseYearStart
-- concat
-- connected
-- constant
-- contains
-- count
-- cross
-- crps
-- cumsub
-- cumsub.fallback
-- cumsum
-
D-E-F
-
G-H-I
-
J-K-L
-
M-N-O
-
P-Q-R
-
S-T-U
-
V-W-X
-
Y-Z
Specifications
Legacy avg avg(T.a : number) 🡒 number, aggregator The aggregator returns the numerical average of the grouped numbers.
Example:
table T = with
[| as A, as B |]
[| 0, "a" |]
[| 0, "a" |]
[| 0, "b" |]
[| 1, "b" |]
[| 1, "c" |]
table G[gdim] = by T.B
where T.B != "c"
show table "" a1b4 with
gdim
avg(T.A)
group by gdim
The aggregator returns 0
on empty groups.