Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How can I add projects within a certain portfolio to an issues report?

Avatar

Level 2

We have a report that displays all issues we received per quarter but I would also like to include all projects created per quarter within a certain portfolio that don't have an issue attached to them (they started directly as a project not as an issue that was converted). I can't figure out the text mode behind this. Thanks for any advice!

Topics

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

1 Reply

Avatar

Employee

@Laura Ernste‚ As reports are object based, you won't be able to pull in projects to an issue report. Instead, it is recommended that you create a separate project report and then add both of these reports to a dashboard so you can view all information at once.

To create a report that pulls in all projects created per quarter within a certain portfolio that were built from scratch (vs a converted issue), you would want to do the following:

-Create a project report

-Add a filter for Project > Portfolio ID > Equal > (Name of Portfolio)

-Add a secondary filter for Project > Entry Date > This Quarter (select it from the dropdown Equal menu)

-Add a third filter for Converted Issue Originator > ID > Is Blank

Let me know if that wasn't exactly what you were looking for!