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 dataMonthSerial # of unit testedJan1001Jan1001Jan1002Feb1002Feb1003Feb1004Mar1005Mar1006Apr1006Apr1006 Desired summarized dataMonth# of tests, prior 3 months# of uniqu...