Date range
Syntax
Example
Output
max(x,range)
Assuming that values are sampled every second: max([1,2,3,−1],"T")
3
min(x,range)
Assuming that values are sampled every hour:min([1,2,3,−1],"4H")
−1
mean(x,range)
Assuming that values are sampled every minute:mean([1,2,3,0,−1],"5T")
1
std(x,range)
Assuming that values are sampled every minute:
std([1,2],"T")
0.707
count(x,range)
Assuming that values are sampled every day:count([1,2,3,0,−1],"W")
5
last(x,range)
Assuming that values are sampled every month:last([1,2,3,0,−1],"4M")
−1
first(x,range)
Assuming that values are sampled every month:first([1,2,3,0,−1],"4M")
1
sum(x,range)
Assuming that values are sampled every minute:sum([1,2,3,0,−1],"4T")
5
Last updated
Was this helpful?