Series Query: Regularize
Description
The underlying series can be regularized by applying periodic aggregation using the FIRST or LAST function and turning on interpolation to fill the gaps created by periods without data. The technique is called "downsampling" in reference to a fewer number of returned data points.
FIRSTreturns the first observed value in the given period.LASTreturns the last observed value in the given period.
Both functions return detailed values, unlike AVERAGE and PERCENTILE functions, which calculate smoothed statistics.
Request
URI
POST /api/v1/series/query
Payload
[
{
"startDate": "2016-06-27T14:10:00Z",
"endDate": "2016-06-27T14:15:00Z",
"entity": "nurswgvml007",
"metric": "cpu_busy",
"aggregate": {
"period": {"count": 1, "unit": "MINUTE"},
"type": "FIRST",
"interpolate": {"type": "LINEAR"}
}
}
]
Response
Payload
[
{
"entity": "nurswgvml007",
"metric": "cpu_busy",
"tags": {},
"type": "HISTORY",
"aggregate": {
"type": "FIRST",
"period": {
"count": 1,
"unit": "MINUTE"
}
},
"data": [
{
"d": "2016-06-27T14:10:00.000Z",
"v": 11.83
},
{
"d": "2016-06-27T14:11:00.000Z",
"v": 6.12
},
{
"d": "2016-06-27T14:12:00.000Z",
"v": 12
},
{
"d": "2016-06-27T14:13:00.000Z",
"v": 3
},
{
"d": "2016-06-27T14:14:00.000Z",
"v": 5.05
}
]
}
]