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 (100) WindowSize (3) Accumulate ('sid', 'id') ) AS dt;
Output
sid | id | cptid |
---|---|---|
1 | 11 | 1 |
1 | 21 | 2 |
1 | 31 | 3 |