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 5mo ago
Copy link