Expand my Community achievements bar.

SOLVED

Report on projects with no tasks

Avatar

Level 2

I have created a project report with a custom column to show the number of tasks for each project.

Text Mode for that column:

aggregator.displayformat=int

aggregator.function=MAX

aggregator.valuefield=project:totalTaskCount

aggregator.valueformat=intAsInt

displayname=# of Tasks

textmode=true

valuefield=project:totalTaskCount

valueformat=HTML

What I'm having a problem with, is setting up a filter for that column to only show me projects with 0 tasks. I'm sure I'm missing something super simple, but thought I'd ask for some help before I spend any more time on this.

Thank you!

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

Of course I found my own answer right after I asked for help. If anyone else needs to know, this filter works to find projects without any tasks.

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=TASK

EXISTS:a:projectID=FIELD:ID

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

Of course I found my own answer right after I asked for help. If anyone else needs to know, this filter works to find projects without any tasks.

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=TASK

EXISTS:a:projectID=FIELD:ID

Avatar

Employee

YES. I love that you found your own answer, but even more that you came back to share it with the community!! Thank you!!