Input
- Output table of ChangePointDetection Example: One Series, Default Options
SQL Call
SELECT * FROM ChangePointDetection ( ON cpt PARTITION BY sid ORDER BY id USING TargetColumn ('val') Accumulate ('sid', 'id') OutputType ('VERBOSE') ) AS dt;
Output
sid id cptid difference --- -- ----- ------------------ 1 8 1 7.4734790324760105 1 11 2 97.35746106876692 1 21 3 48.67501782818529 1 31 4 52.08839257625203 1 34 5 3.7188850706639904
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.