I have been planning around with a report and can't seem to figure it out. I would like to make a report that shows tasks completed in a certain month. IE 9/1/21 to 9/30/21. Then I would like it to pull the people attached to a certain team but it might not be their home team. Anyone have some advice for this? Thanks
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Hi Heidi!
This might work for you. If you use this code in a task report, it will show any tasks that meet the following criteria:
EXISTS:a:$$OBJCODE=USER
EXISTS:a:ID=FIELD:assignedToID
EXISTS:a:teams:name=Email Team
actualCompletionDate=$$TODAYbm
actualCompletionDate_Mod=gte
status=CPL
status_Mod=in
If you need to make your own filters, build them in standard mode. Then, switch to text mode and add the 3 rows of EXISTS filters to the end of your code.
Chloe
Views
Replies
Total Likes
Hi Heidi!
This might work for you. If you use this code in a task report, it will show any tasks that meet the following criteria:
EXISTS:a:$$OBJCODE=USER
EXISTS:a:ID=FIELD:assignedToID
EXISTS:a:teams:name=Email Team
actualCompletionDate=$$TODAYbm
actualCompletionDate_Mod=gte
status=CPL
status_Mod=in
If you need to make your own filters, build them in standard mode. Then, switch to text mode and add the 3 rows of EXISTS filters to the end of your code.
Chloe
Views
Replies
Total Likes
Amazing thank you
Views
Replies
Total Likes
@Chloe Rock‚
Possible to get report for specific user with planned hours each week. For example if the task started in week 10 and completion is in week 30 with total of 200 planned hours. That means it should show 10 hours each week wise in the chart column. Any guidance in this regard. Sorry I am not aware much about text code, your guidance higly appreciated.
Mvh
Kundan.
Views
Replies
Total Likes
Views
Likes
Replies