The subject says it all. Does anyone know how to add a column in the Programs view that shows how many projects are under each program? I would want to filter out complete, dead, etc.
TIA!
Solved! Go to Solution.
Views
Replies
Total Likes
I would recommend just using an exists statement in your filter in that case. Something like
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=PROJ
EXISTS:a:programID=FIELD:ID
Hi Justin,
If you just need the project count it would be easier to create a project report and group by program. This will allow you to: (a) get a count of projects by program, and (b) create a bar chart to visually display the data.
- Matt
Views
Replies
Total Likes
I'm hoping to target programs with 0 projects under them - this would not show up in a project report.
Views
Replies
Total Likes
I would recommend just using an exists statement in your filter in that case. Something like
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=PROJ
EXISTS:a:programID=FIELD:ID
Hi Justin - you can't count a collection unfortunately but you can list the projects if that helps your scenario in anyway.
valueformat=HTML
textmode=true
type=iterate
listdelimiter=<p>
displayname=Project Names
listmethod=nested(projects).lists
valuefield=name
I believe it's possible to count and return a value to a custom field on a program custom form if you have Fusion.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies