In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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
6 - Meteoroid

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
binu_acs
21 - Polaris

@rdlouviere can you upload the input file?

rdlouviere
6 - Meteoroid

Here is the input file. 

binu_acs
21 - Polaris

@rdlouviere Are you looking for something like below

image.png

Labels
Top Solution Authors