Find average days between transaction for each member type

natalie_mejia

Hello! I am new to Alteryx and would like to get started on this workflow, but I  am not sure where to begin. I have data that includes a contact id along with a unique transaction ID referencing each contribution made by that contact. Some contact ID's repeat because they make multiple transactions. In addition, there is a transaction close date for each transaction. What i need done is the following:

• Group contact id's that are the same 
• Separate by contact type (Dog, Cat, or Organization)
• Find the average days between transaction close dates for each contact id and thus for each contact type

I have attached sample of data along with the results I would like to receive from the workflow.

contact id grouping.xlsx

atcodedog05

Hi @natalie_mejia 

Here is how you can do it:

Workflow:

1. Using formula tool create a category column for dogs, cats and organization.

2. Using formula tool for converting date into alteryx supported date.

3. Using multi-row formula groupby on customer id finding days between.

4. Using summarize groupby category and find avg of days between.

Hope this helps 🙂

dogs and cats.yxmd