This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Transaction Analytics Engineer at Bank of America. The fraud operations team wants a smoothed view of daily transaction volume per account to detect unusual spikes. For each account, compute the daily total of posted transactions and a 3-row trailing moving average of that total (current row plus the two preceding rows).
You are a Transaction Analytics Engineer at Bank of America. The fraud operations team wants a smoothed view of daily transaction volume per account to detect unusual spikes. For each account, compute the daily total of posted transactions and a 3-row trailing moving average of that total (current row plus the two preceding rows).