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
Hi @nidah5, you could use the Pearson or Spearman correlation tools within the Data Investigation tool palette to compute your correlations:
I need to use pearson method which doesn't have group by function
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...
@jdunkerley79 yes indeed using batch macro does solve the problem.
Attached is how the solution will look like on @nidah5 's data: