This topic describes the sequence decomposition function that you can use to decompose business curves and highlight the information about the curve trends and periods.
ts_decompose
Function format:
select ts_decompose(x, y) The following table lists the parameters of the function.
Parameter | Description | Value |
x | The time sequence. The points in time along the horizontal axis are sorted in ascending order. | Each point in time is a Unix timestamp. Unit: seconds. |
y | The sequence of the numeric values of the property under observation, corresponding to the specified points in time. | N/A |
Example
The query statement is as follows:
* | select ts_decompose(stamp, value) from (select'("__time__" - ("__time__" % 60))' as stamp, avg(v) as value from log GROUP BY stamp order by stamp)Output result
The following table lists the display items.
Display item | Description | |
Horizontal axis | unixtime | The Unix timestamp of the data. Unit: seconds. |
Vertical axis | src | The raw data. |
trend | The decomposed curve trend. | |
season | The decomposed curve period. | |
residual | The decomposed residual data. | |