Unexpected “ghost” values in Window recipe (sum and count not matching)

Hey everyone, im new here

I’m facing a weird issue with the Window recipe while trying to compute rolling transaction metrics — specifically sum and count over 1-day, 7-day, and 30-day periods.

Here’s my setup:

• Partitioned by cc_num
• Ordered by trans_date_trans_time
• Using a window frame (either limit by range in days/hourse or limit by rows i tried all of em)
• I created two separate Window recipes — one for sum and another for count of transactions

The problem is that I’m getting some strange “ghost” accumulation values.

Example:
Let’s say for a single customer I have only two transactions in a day — $5 and $7.
Logically, I expect:

• Transaction 1 → total = $5, count = 1
• Transaction 2 → total = $12, count = 2

But instead, I sometimes get:

• Transaction 1 → total = $5, count = 5 (?!?)
• Transaction 2 → total = $30, count = 7

It’s as if the window is summing or counting transactions that don’t actually exist yet — like it’s pulling data from outside the date range. fyi i use firs record for my sample so its kinda weird

Can anyone help me? Any thoughts, tips, or debugging ideas would be much appreciated 🙏