In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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