lag correlation

Question

I have dataset with Customer, date, revenue and the count of complaint raised.

i need to find out the correlation between revenue and the lag count of complaints but with -3 month of count of complaints(rev_inc_lag,).

the workflow uploaded has all the fields calculated, want to find correlation using pearson for each customer in a month

alteryx_lag_corr.yxmd

seinchyiwoo · Answer

@jdunkerley79 yes indeed using batch macro does solve the problem.

Attached is how the solution will look like on @nidah5 's data:

alteryx_lag_corr.yxzp

jdunkerley79 · Answer

One option would be to use a batch macro and run it one group at a time, though this would be pretty slow for a large set. Alternatively you can recreate the Pearson correlation from first principals using a summarise tool.

I'd suggest looking https://community.alteryx.com/t5/Alteryx-Designer-Discussions/creating-Loop-for-correllation/m-p/634000

nidah5 · Answer

I need to use pearson method which doesn't have group by function