We use the auto-correlation function. We see how to implement it in WarpScript™, with an exact calculation and then with a fast and accurate approximation.
WarpScript equivalent to SELECT WHERE requests is a basic GTS sum. You just need to build a new GTS to select interesting data from the original one!
Comparing Flux and Warp 10 WarpScript on simple analytics use case. Keep in mind WarpScript was designed for timeseries analytics !
Use WarpScript™ to Simplify Time Series analytics. Robusts solutions exists to work with Time Series. Do not reinvent the wheel!