This article provides detailed explanations on the report and dashboard parameters available in PPO:
- Project List;
- Project Filter;
- Project Filter Combo;
- Entity List;
- Entity Filters;
- Group By;
- Sort By;
- Date Parameter;
- Drop Down List;
- Check Box.
The project list parameter allows users to extract a report for only one project at a time. The user can also disable the global filter by clicking on the Global Filter toggle next to the project list parameter, in order to pull the report or dashboard for filtered out / closed projects.
An example of a dashboard where a project list parameter is used is the Project Status Dashboard.
A project filter parameter allows users to pull the report for multiple projects at a time. The user can select to view the report for all projects, to set up a personal filter to view only selected projects or to apply one of the shared filters. For more information on shared filters, see the following knowledge base article.
The user can also disable the global filter by clicking on the Global Filter toggle next to the project filter parameter, in order to pull the report or dashboard for filtered out / closed projects.
Examples of reports and dashboards that make use of a project filter parameter include the Portfolio View dashboard, the Portfolio Governance report and the Portfolio Quality report.
A project filter combo is a combination of the project list parameter and the project filter parameter. It provides a project list in order to select a single project, as well as an option to specify a filter to show multiple projects.
The user can also disable the global filter by clicking on the Global Filter toggle to show filtered out / completed projects.
Examples of reports and dashboards that make use of a project filter combo are the Alert and Reminder report, the Portfolio dashboard and the Risks dashboard.
PPO makes use of entity list parameters to define report parameters in terms of project related entities. For example, the Scrum - Sprint Backlog dashboard makes use of an entity list to select which Sprint the report must show for.
Similar to project filters, entity filters are used to specify multiple entity records that should appear on the report or dashboard.
Examples of reports and dashboards that make use of entity filters are the Issues report, Risks report and the Costs dashboard.
A Group By parameter allows users to categorise the information on a report into groups based on a selected field or value. If a group by parameter is available on a report, a list of all group-able fields will be shown in the parameters section.
Examples of reports and dashboards that make use of a group by parameter are the Data Completeness report, Portfolio Quality report and Costs dashboard.
The information on the report will appear in grouped sections based on the group by field selected. For example, if a group by Phase is selected on the Portfolio Quality report, the project list will be grouped based on the Phase selected on each project.
PPO allows users to select the order in which records appear on a report or dashboard by making use of a Sort By parameter. This parameter will typically show all fields appearing on the report, allowing the user to select which field according to which the data must be sorted.
An example of a dashboard that makes use of a sort by parameter is the Portfolio View dashboard.
PPO allows users to select a date range that needs to be applied to a report by making use of a date parameter. The date parameter normally consists of two date fields, i.e. a start date and an end date which should apply to the report data.
Examples of reports that make use of a date parameter is the Time Entry Detail Report.
PPO occasionally makes use of a drop-down list to define a report's parameters.
An example of a dashboard where a drop down list is used as a parameter is the Planning Dashboard:
PPO uses a check box as an option to add information to a report or dashboard. For example, all detail reports include an option to add project data to the report.
An example of a report that makes use of a check box is the Finance Data report.