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. | Community
Skip to main content
TimothyBr
TimothyBr
Level 4
July 16, 2025
Solved

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.

  • July 16, 2025
  • 3 replies
  • 760 views

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....

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

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 @mattmi3  (I think my math added up but just in case I made any errors in my assumption)

3 replies

L
ljorr16
Level 3
July 16, 2025

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
    TimothyBrAuthor
    Level 4
    July 16, 2025

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

     

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe ChampionAccepted solution
    July 16, 2025

    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 @mattmi3  (I think my math added up but just in case I made any errors in my assumption)

      L
      ljorr16
      Level 3
      July 16, 2025

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

      skyehansen
      Community Advisor and Adobe Champion
      skyehansenCommunity Advisor and Adobe Champion
      July 16, 2025

      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).

        MoniqueEvans
        Community Advisor
        MoniqueEvansCommunity Advisor
        Community Advisor
        July 17, 2025

        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

        L
        ljorr16
        Level 3
        July 17, 2025

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

          Terms & ConditionsAccessibility statement

          Loading footer...