The challenge focuses on analyzing automotive production data to identify the year with the highest number of distinct car models that stopped being produced relative to the prior year.
- Alteryx Designer
- Multi-Row Formula
- Join
- Summarize
- Filter
- Sort
Determine which two years had the most distinct new models launched and from which brands were these models launched.
Identify the year with the highest number of distinct models that stopped being produced, relative to the prior year. Count each model that was produced in year Y but not in year Y+1 as “extinct,” even if it returns in later years.
