Ageing

[Phani_1982]

Defects Months	Ageing Count	Ageing
10,11,12	3	61-90 Days
08,09,12	3	61-90 Days
08,09,12	3	61-90 Days

first row of defective months are consecutive months and last 2 rows are not consecutive and should be considered as first month for 12th month  should be 0-30 days in ageing please help me with the formula

[ChrisTX]

Is there a question about Alteryx functionality?

[apathetichell]

@ChrisTX --- throw Alteryx licenses at some consultants. don't give them any training. bill per hour -> tell them to go to Community for help. Great business model.