Sorting a report by number of requests (or tasks) someone is assigned to

Forum|Forum|1 year ago
July 10, 2024
2 replies
922 views

Overall, I am pulling a report on how many requests certain users are assigned to that hit a specific criteria (i.e. the users assigned to requests with the highest scores). Then I am looking to sort by who is assigned to the most down to the least.

Problem, I cannot think of a way to sort by the count of assignments

Any feedback would help!

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Richard_Carlson

Community Advisor

I would start with a task report with some kind of filter so that you get tasks on active projects and not closed projects. Then, add a column to show who or what role assigned the task in the report. The act of assigning a task to someone is an event that can be reported on in Workfront to the best of my knowledge. Once you have this column in the report you can sort by it.

skyehansen

There's currently no way to sort by assignment count from highest to lowest. If that's a priority for your company, you should talk to @doug_den_hoed__atappstore

https://store.atappstore.com/product/magic-reports/