Community Advisor

Question

List task count for each project in a project report. I can't think of a good way to do this.

Forum|Forum|4 years ago
April 8, 2021
5 replies
2627 views

I could make a task report and group it by project and see the aggregated task count in the group headers but it would be a gigantically huge long report that would take a while to load.

Has anyone done anything like this with a project report?

Would counting a collection work?

Maybe do a nested(tasks).lists and then do a count?

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

T

TealeMcCleaf

Level 6

Hi Randy -

I found some notes that someone posted here a while back that I think will solve your issue.

"I know you are looking for a single view you can export that shows project name, project reference number and total number of tasks, so like a matrix report, you could also do the following:

1. Create a Task Report

2. Filter for Task > Number of Children > Equals > 0

3. Before you add/remove any columns, go to the Groupings tab and group the results by Project Name

4. Go back to columns and remove all. Add in Project Name, Project Reference Number (In the column settings, summarize this column by MAXIMUM) and this one for total tasks, using the below text mode:

aggregator.displayformat=int

aggregator.function=MAX

aggregator.valuefield=project:totalTaskCount

aggregator.valueformat=intAsInt

displayname=# of Tasks

textmode=true

valuefield=project:totalTaskCount

valueformat=HTML

4. Save and close your report.

5. This should give you two tabs - Details & Summary. The Details tab will ultimately be a row for each task that meets the criteria, but the Summary tab is what is shown in the grouping bar.

In your case, the Summary tab will include Project Name, Project Reference Number, Total # of Tasks and Total Count (which is the # of tasks that meet the criteria of number of children = 0). You can then export this tab into Excel and remove the Total Count column so that you have 3 columns. "

I was able to duplicate this and in the Report Settings, set the Summary Tab as the view when the report loads and I see the total number of tasks per project.

Hope this helps,

Teale

Kundanism

Level 10

Hi @Teale McCleaf‚

Thanks for sharing this detailed info. It really works.

Thanks a lot once again.

Mvh

Kundan.

T

TealeMcCleaf

Level 6

You're very welcome! Always happy to help.

Doug_Den_Hoed_AtAppStore

Community Advisor

Hi Randy,

I can offer a couple of suggestions, depending on your needs. First, the Raw Data (geeky way):

in chrome, install the JSONView plugin (so the results are readable)
log in to [yourdomain]
enter this in the browser tab then hit [Enter]: https://[yourdomain].my.workfront.com/attask/api/v10.0/task/report?project:name_1_GroupBy=true
viola: that's your numbers...export to excel and format as needed

Second, noting that on every project, the last task's number is in fact also the same as the count of the tasks (sneaky way):

Create a Task report with View = Project Name, Task Number (Max, descending), group by Task Number, Project Name
Add a bar Chart
Run the report, then click any bar to see those Projects with that many tasks (see below)
Or look at the details
Or make it a matrix

Regards,

Doug

RandyRoberts

Author

Community Advisor

So both of these methods get me the end result I want. I was looking for maybe just a column that I could add to an existing project report that had a task count. But that would have been too easy!

But now I'm more interested in the API query you posted. I use URL style API queries all the time but I haven't seen anything like this one. I've never used the report query. Usually I use the "search?" query.

How does "report?project:name_1_GroupBy=true" work? Is there any documentation anywhere on that? I know it's asking a lot for there to be documentation on something but hey, if you don't ask, you don't get.