lag correlation

[nidah5]

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

[AbhilashR]

Hi @nidah5, you could use the Pearson or Spearman correlation tools within the Data Investigation tool palette to compute your correlations:

[nidah5]

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

[jdunkerley79]

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/634...

[seinchyiwoo]

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

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