Input
- Output table of ChangePointDetection Example 2: One Series, Default Options
SQL Call
SELECT * FROM ChangePointDetection (
ON cpt PARTITION BY sid ORDER BY id
USING
ValueColumn ('val')
Accumulate ('sid', 'id')
OutputOption ('VERBOSE')
) AS dt ORDER BY sid, id;
Output
| sid | id | cptid | difference |
|---|---|---|---|
| 1 | 8 | 1 | 7.47347903247601 |
| 1 | 11 | 2 | 97.3574610687669 |
| 1 | 21 | 3 | 48.6750178281853 |
| 1 | 31 | 4 | 52.088392576252 |
| 1 | 34 | 5 | 3.71888507066399 |