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 help categorize Community content and increase your ability to discover relevant content.
@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!