The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
I found I got different solutions when I sorted the weekly transactions in descending order and sampled the first 5 vs. when I sorted the weekly transactions in ascending order and sampled the last 5. This indicated to me that multiple employees shared the 5th highest average number of expense reports. Thus, I figured out what that 5th highest average number of expense reports was and showed all employees (10 in total) with that average number of reports or higher.