Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

# of projects for task users

Avatar

Level 10
Hello. I want to find out how many projects each user in the system have worked on within certain date parameters. I've tried using a project report but I am only able to get groupings done by Sponsor or Owner. I've also tried to use a task report but since there are many tasks per user in each project and I cannot make project name to be "unique only" in the report, I'm not getting the numbers I need. Anybody with an idea how to do this?
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies

Avatar

Level 10
Hi: You’ll want to use the Assignment reporting object. You can filter assignments by person (Owner), by date range (Entry Date), and show the Project Name. You might need to do a Grouping or Matrix report to get summary information. Does this help? Eric

Avatar

Level 10
Oops, scratch that. I gave you the wrong information. I was thinking of a report that would tell you what people are scheduled to work on. I realized that is not what you asked for. You’ll want a report on the Hours reporting object to show what people worked on in the past - assuming you’re using timesheets to charge time to projects. If you’re not charging time to projects, um, not sure how to show what happened in the past. Create a standard Hour report; Add the Project Name to the list of attributes; Standard Grouping - Click the Project Name; Add a filter to pick the date range you want (Hour >> Entry Date Greater than or equal to Jan 1,2016, for example); Add a filter to pick the person you want (Hour >> Owner ID equal Eric Lucas); Run it. Look at the summary tab. Is that what you want? [cid:image001.jpg@01D1DCE5.E5738630] Eric

Avatar

Level 10
Hi Eric, Not quite what I needed. I want to see User A 90 projects User B 25 projects User C 28 projects It's a comparison between users and the number of projects they are involved in. Thanks.

Avatar

Level 10
Hi - When you say involved in, can we say we want to count the projects they are scheduled to work on or the projects they have worked on in the past? The answer to that tells me whether I have an Hour report or an Assignment report. Thanks!

Avatar

Level 10
Hi - I'll give you an update. I built an Hour report, since that is the only way to tie work a person did to a project. What I can't figure out how to do is count the number of unique project names, by user, and display that. I can easily dump the Hour data out to Excel and do a pivot table that gives me everything straight away. I don't have enough reporting text mode experience to know how to normalize the project names by user in the hour reporting object. Sorry I don't have a solution :disappointed_face:

Avatar

Level 10
Thanks for trying Eric. I just thought that there is a way to do it in Workfront so I can have it as part of a dashboard rather than having to export stuff to excel. I've also been looking into the community on how to get only unique items to report and I've seen other post about it not being available. I guess it's time to send this in as a feature request.

Avatar

Level 10
Sad but true. If you have a lot of reporting to do, you can get a scheduled extract of your workfront database, upload it to a server, and then do nifty dashboards from that. Check out the database extract capabilities from the AtApp Store ( http://www.atappstore.com/) Eric

Avatar

Level 5
I second the opinion on the AtAppStore snapshot tool. They've really built a nice set of power tools to get things done. I'm also available for coaching and assistance on dashboards and reporting. Melinda Layten mlayten@gmail.com Independent Workfront Consultant

Avatar

Level 5

You can create an hours report that is filtered for your time period and grouped by user.

You then need to add the Project Reference Number as a column and summarize the column by count.

This will equal the number of entries, so not what you want.

Edit the column and switch to text mode. Change CNT to DCNT

This is Distinct Count and will give you what you want. It doesn't always work correctly on the overall totals, but each sub-total will be right.

The whole text mode will look like this:

aggregator.displayformat=int aggregator.function=DCNT aggregator.namekey=view.relatedcolumn aggregator.namekeyargkey.0=project aggregator.namekeyargkey.1=referenceNumber aggregator.valuefield=project:referenceNumber aggregator.valueformat=intAsInt displayname= linkedname=project namekey=view.relatedcolumn namekeyargkey.0=project namekeyargkey.1=referenceNumber querysort=project:referenceNumber textmode=true valuefield=project:referenceNumber valueformat=int

Melinda Layten

mlayten@gmail.com

Independent Workfront Consultant0690z000007ZkXrAAK.jpg

Avatar

Level 10
Hi Melinda, this is just fantastic! It works very well. DCNT does not come up on the help site, but I'm pretty sure being able to count unique/distinct items is important. Thank you again for all your help!