How to script a rolling count using Table Summary?I am trying to find a way to summarize a table over a rolling 3 month period. I’ve tried different approaches with the ‘lag’ and ‘col rolling’ functions but haven’t had success yet. Any advice? I am using JMP 16
Example original data
Month | Serial # of unit tested |
Jan | 1001 |
Jan | 1001 |
Jan | 1002 |
Feb | 1002 |
Feb | 1003 |
Feb | 1004 |
Mar | 1005 |
Mar | 1006 |
Apr | 1006 |
Apr | 1006 |
Desired summarized data
Month | # of tests, prior 3 months | # of unique SN tested, prior 3 months |
Jan | 3 | 2 |
Feb | 6 | 4 |
Mar | 8 | 6 |
Apr | 7 | 5 |
Quality and Process EngineeringScripting
