Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Grouping data

AuditPro13
8 - Asteroid

I have a table with a bunch of loan accounts in column A and the data related to those loan accounts in the following columns, one of them being "# of days past due" which include the exact number of days that account is passed due. I want to group the loans together based on a range of days past due (1-30,31-60,61-90,and 90+) and pull the related data into those groups including a count of how many loans fall into that pool, the sum of the past due amount, and the sum of the principle balance for the loans in each days past due group.  

 

3 REPLIES 3
KOBoyle
11 - Bolide

Regarding the first part your question, this came up recently in a thread called Aging Buckets https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Aging-Buckets/m-p/307697#M54934. One approach would be to use a Formula like the one described there. Once you have a new Bucket column, you could then use the Transform:Summarize tool: Bucket - Group By, Loan - Count, Amount - Sum. You could then use Transform:Crosstab to put the buckets into columns.

ivoller
12 - Quasar

I think this is also a good use case for a manual Tile tool. See attached.

 

2018-10-04_17-31-35.png

AuditPro13
8 - Asteroid

Beautiful. Thank you.

Labels