Need help in finding project name in group resource aggregate monthly table

cn505666
Tera Contributor
 
2 REPLIES 2

Namita Mishra
ServiceNow Employee
ServiceNow Employee

Hi @cn505666 ,

Thanks for raising the query with community. 

As a best practice always explain your question so that team can understand and share the best response.

Below is the screenshot of resource_aggregate_monthly table and task provides the task idenrification number such as project id.

Hope this helps and if it does please mark the response as correct to help me and others in the community.

 

Screenshot 2025-07-23 at 10.02.30 AM.png

 

Happy SPM Learning!!

 

Thank You!

Namita Mishra

Let me explain the exact scenario: This requirement is pertaining to Resource management where utilization report over and under by resource group and by project has been provided in a pivot format. Now The users want me to add project name or short description, then must contain only BTS group, month starts on: current month + 2.

cn505666_0-1753447391305.png

 

But when i am adding short description or task, it is giving me a message "Cannot generate the report. This report contains too much data to visualize. Add filter conditions to reduce the amount of data."

 

I was able to add filter condition for "must contain only BTS group" & "current month +2". But unable to add project name (could not find) or description. throwing me the above message mentioned in bold

 

Kindly help me with this please