MicroStrategy ONE
Pattern Functions
Sequential Pattern Matching (SPM) takes an input table, sorts it in a specified sequence, then scans through the rows looking for a pattern across rows, and then returns aggregate information based on the matching rows.