Alteryx Designer Desktop Discussions

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

Output data by Ranges of a specific column - Aging Data

rdlouviere
5 - Atom

I created a formula to calculate the aging of a set of data - how old an invoice is. Now I want to take the data and group by a range of this aging to output my data summary. 

 

In other words, I want to create a table that shows how many of each category or exception reason I have that are between 0 and 10 days, 11-30 days, 31-60 days, 61-90 days, 91-120 days, and over 120 days. 

3 REPLIES 3
binuacs
21 - Polaris

@rdlouviere can you upload the input file?

rdlouviere
5 - Atom

Here is the input file. 

binuacs
21 - Polaris

@rdlouviere Are you looking for something like below

image.png

Labels
Top Solution Authors