Input
- Output table of ChangePointDetection Example 2: One Series, Default Options
SQL Call
SELECT * FROM ChangePointDetectionRT ( ON cpt PARTITION BY sid ORDER BY id USING TargetColumn ('val') ChangePointThreshold (20) WindowSize (3) OutputType ('VERBOSE') Accumulate ('sid', 'id') ) AS dt;
Output
sid | id | cptid | difference |
---|---|---|---|
1 | 11 | 1 | 40764.171204234 |
1 | 21 | 2 | 41833.8977039489 |
1 | 31 | 3 | 48358.164361325 |
1 | 36 | 4 | 27.7125810367931 |