Database Reference
In-Depth Information
Other stat functions
There are numerous other stat functions available. Here are some of the most common
ones:
Stats function
Description
avg(X)
Returns the average value of field X
dc(X)
Returns the distinct count of field X
earliest(X) Returns the earliest value of field X, chronologically
last(X)
Returns the last seen value of field X
Returns the latest value of field X, chronologically
latest(X)
list(X)
Returns the list of all values of field X as a multi-value entry
Returns the maximum value of field X
max(X)
median(X)
Returns the middle value of all values of field X
Returns the minimum value of field X
min(X)
mode(X)
Returns the most frequent value of field X
perc<X>(Y) Returns the X-th percentile value of field Y
Returns the range (max-min) of field X
range(X)
stdev(X)
Returns the standard deviation of field X
Search WWH ::




Custom Search