Links

Date range

Syntax
Example
Output
max(x,range)max(x, range)
Assuming that values are sampled every second:
max([1,2,3,1],"T")max([1, 2, 3, -1], "T")
33
min(x,range)min(x, range)
Assuming that values are sampled every hour:
min([1,2,3,1],"4H")min([1, 2, 3, -1], "4H")
1-1
mean(x,range)mean(x, range)
Assuming that values are sampled every minute:
mean([1,2,3,0,1],"5T")mean([1, 2, 3, 0, -1], "5T")
11
std(x,range)std(x, range)
Assuming that values are sampled every minute:
std([1,2],"T")std([1, 2], "T")
0.7070.707
count(x,range)count(x, range)
Assuming that values are sampled every day:
count([1,2,3,0,1],"W")count([1, 2, 3, 0, -1], "W")
55
last(x,range)last(x, range)
Assuming that values are sampled every month:
last([1,2,3,0,1],"4M")last([1, 2, 3, 0, -1], "4M")
1-1
first(x,range)first(x, range)
Assuming that values are sampled every month:
first([1,2,3,0,1],"4M")first([1, 2, 3, 0, -1], "4M")
11
sum(x,range)sum(x, range)
Assuming that values are sampled every minute:
sum([1,2,3,0,1],"4T")sum([1, 2, 3, 0, -1], "4T")
55
Last modified 9mo ago