Is there ANY WAY to build a report that just shows the number of projects someone worked on, but the report being for a list of people.

[TimothyBr]

I have asked this in the past,  and there never seems to be a good response.

We need a report that will say something on the lines of:
- Show me all of the project a list of people worked on, grouped by person.
- The list of people would be driven by Team IDs

We DO NOT:
1. An assignment report that shows all of the tasks someone was assigned. We just want it at the project level

2. We DO NOT want to create a dashboard that would be one report per person.

Overall:
We just want to be able to see the number of projects someone supported but in a report that shows everyone within that group. I would be baffled if we cannot do this, it seems to be a pretty simple project management tool ask....

[ljorr16]

Hi! I had a very similar question!

The bad news is there doesn't seem to be a native way to do this in Workfront (which I find surprising).

The good news is that another user shared text mode that allowed me to get to the information I needed. You can't put it in a nice chart (alas) but at least the data is there.

Check it out in this thread: Re: Need to create a chart that shows how many projects a user has been on

Hope that helps!

[TimothyBr]

I want to check out the canvas dashboard as well, but this may be a fix solution to get me there for now! 

[skyehansen · Accepted solution]

I'm wondering if you have tried the canvas dashboards beta. (are you signed up for this?)

if you are signed up, I would have you try creating a column chart to start with. Go with a left (Y) axis that is "Assignment | Project | Name" and aggregation type "Count Distinct"

Bottom X axis would be "Assignment | Assigned to | Name"

cc to @mattmitchell  (I think my math added up but just in case I made any errors in my assumption)

[ljorr16]

Oh hot dog! I tried to figure this out but couldn't since I'm new to Canvas Dashboards. But this works!! Thanks!

[skyehansen]

great good to hear it worked for you @ljorr16  -- the instructions I made for myself (and other beginners) are:

1. “What are you measuring/counting?” (Y Axis)
   (in this case, we are counting number of projects)
2. “How do you want to group that?” (X Axis)
   (by the assigned to user)
3. The initial object you pick is probably going to be the type of report this is (or another way to look at this is what you can filter by)
   (we wanted to filter by assigned to users)

More beginner stuff which might be useful: build the report in the legacy reporting tool, then use the “chart” section as a reference for how to configure the canvas report (it contains helpful Y-axis/X-axis labels to help you remember).

[TimothyBr]

I am in canvas dashboards (I believe), but new to it. 

Do I go to Dashboards first? And then where from there? 

Overall, how to get start with the Canvas Dashboards, and I can figure it out from there. 

Thanks!

[ljorr16]

It's a little tricky -- I went to my dashboards area from the main menu, then I saw Canvas Dashboards on the left. It looks really different from the traditional reporting but if you follow the instructions from @skyehansen you'll get there!

[TimothyBr]

Ah, there is an issue with our instance where I dont see this. Thanks and I have submitted a helpdesk ticket! 

[skyehansen]

@TimothyBr  -- here's the available docu on canvas:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/canvas-dashboards/canvas-dashbo...

[MoniqueEvans]

I second everything Skye is saying. In addition to the project count by user chart you might want a KPI metric (also an option in Canvas Dashboards) to flat out say the number of unique projects this team has assignments within. You would build it in a very similar way as Skye suggested however you would select KPI instead of Chart as your first step.

If you do not have Canvas Dashboards this would be very difficult (but not impossible) with Classic Reporting. I haven't tried building it myself but my brain immediately goes to creating a Project report and setting up some sort of exists filter for the Project Team. Because you want Project count it needs to be a Project report (not assignments). And because you want to include anytime a user from a specific team is in the assignments (not just assigned to) I lean towards the Project Users field

[ljorr16]

That's awesome, thank you!! We were able to sweet talk our way into Canvas Dashboards, which I can see is already very helpful!