I am trying to create a project report that filters out all tasks without a milestone and show all the milestone tasks and their percent complete.
The field I created:
displayname=Milestone Tracking
listdelimiter=<br>
listmethod=collected(tasks).list
textmode=true
type=iterate
valueexpression=CONCAT({milestone}.{name},"| ",{percentComplete},"%")
valueformat=HTML
and the filter:
tasks:milestoneID=0
tasks:milestoneID_Mod=notblank
For each project, I return all tasks instead of milestone tasks. Does anyone know how to filter out non-milestone tasks correctly?
Thank you,
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
My approach is a little different. Instead, I only filter on projects that have a milestone path ID.
milestonePathID=59a821d6001d691642ee19889233333d
milestonePathID_Mod=in
Then, as columns in the report, I grab the data. For example:
displayname=Plan
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({milestone}.{name}="Plan",CONCAT({percentComplete},"%"))
valueformat=HTML
displayname=Build
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({milestone}.{name}="Plan",CONCAT({percentComplete},"%"))
valueformat=HTML
displayname=Approval
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({milestone}.{name}="Approval",CONCAT({percentComplete},"%"))
valueformat=HTML
Views
Replies
Total Likes
Excellent. Now you can build milestone reports and pull in whatever you wish off those milestone tasks. Pretty useful. Also, I forgot one thing...
Use the <div> listdelimiter instead. I hear it provides the best view of all in dashboards and in exports.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies