Date range

SyntaxExampleOutput

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 updated