Hi Patrick, I am dealing with big data ( and sensitive data ) , so I can't post any actual data here, running 9.3 on Solaris. I think I have come up with a solution that works, but I wanted to see if this was a problem that someone had already solved previously, and a more compact solution was available. Sample data would be something like ID1 ID2 DTTIME 7D_COUNT 1 1 03aug2014:11:52:57 0 1 2 03aug2014:13:48:47 1 1 2 10aug2014:11:44:58 2 1 2 10aug2014:13:20:51 1 Thanks Todd
... View more