Input
- Output table of ChangePointDetection Example: 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.17120423399 1 21 2 41833.897703948904 1 31 3 48358.16436132501 1 36 4 27.71258103679313
Download a zip file of all examples and a SQL script file that creates their input tables.