Cortex Project History | Project Collection
Work with the project collection
The project collection provides a tabular layout of all the projects that meet your browse or search criteria. This view is helpful for reviewing projects at a high level and identifying project trends.
There are three types of project records included in a collection: Program projects, Projects, and Subprojects.
- A Project (indicated by a
icon) is a distinct effort with its own scope, goals, and deliverables. Projects can exist independently or can be organized under a Program as a subproject. - A Program Project (indicated by a
icon) is a project that contains and organizes one or more subprojects that collectively support a larger initiative. - A Subproject (indicated by a
icon) is a project that is associated with and managed under a Program Project. Each subproject represents a specific scope of work that contributes to the Program's overall objectives.
You can add, remove, reorder, apply filters and sort columns within the collection.
Tips
Published Project programs, Projects, and Subprojects will have a white background. Any pending projects will be highlighted.
To be able to view which projects in the collection are included in a program, you will need the Program project column to be visible. If it's not already visible, follow these steps:
- Open the grid view settings by clicking
(settings). - Select Settings from the drop down menu.
- Add Program project to the Selected column and click Apply.
If a project is part of a program collection, the name of the program will display in the Program project column. You can click on the Program name in the column to open and view it's details. Also, if a project is assigned to a program, in the Attributes tab of an open project you can see the Program name listed in the System block of the attributes.
How do I?
Find a project, program project, or subproject
You can browse for a projects, or use the search and sort features to help you find a project.
Filter the Projects Collection or Search Results
You can filter projects in the search results or a project collection.
To filter projects by attribute
- In the project search results or project collection, click
to expand the Project filters pane if it is not already open. - Select the attributes to use for filtering the search results. You can specify ranges for numeric and date attributes.
- If the projects have different units of measure for a filter option, a unit list is available so you can select one or more units for filtering.
- To clear all the filters, click Clear all.
- To collapse the Project filters pane, click
. - To filter projects by a column
- Hover on the column heading and click
to open the filter window. - Complete the settings in the filter window. The settings vary based on the field type:
- Alphanumeric field: Select the values you want to filter by. For example, when you filter by Project location, select the cities you want to filter the results by.
- Numeric field: Select a comparison operator (Greater than, Equals, Not equal, Less than, etc.) from the list and enter a value in the box.
- To set another condition for the filter, select AND (a project must meet both conditions) or OR (a project can meet either or both conditions), select another comparison operator, and enter a value for the condition. Repeat this process to set additional filter conditions, as needed.
- Date field: Select a comparison operator (Greater than, Equals, Not equal, Less than, etc.) from the list and select or enter a date for filtering the results.
- To set another condition for the filter, select AND (a project must meet both conditions) or OR (a project can meet either or both conditions), select another comparison operator, and enter a value for the condition.
- Click Apply to apply the column filter.
- Repeat steps 1-3 to set additional column filters as needed.
- To clear a filter, hover on the column heading, click
, and click Reset in the filter pane.
View more information about a project
- From the project collection, click on the Project name to open the single project page. The single project page shows project highlights and details, including a project image, key project information, attributes, and elements.
- Open the project information pane if not already open.
- View other donut charts and manage chart settings for the project.
- To view Similar projects, click the link at the bottom of the pane. If Cortex Project History contains other projects similar to this one, a Similar projects link appears at the bottom of the project information pane and shows the number of similar projects in parentheses; e.g., Similar projects (10).
Click
on the title bar to display the current project and other similar projects displayed side-by-side in a tabular layout. The current project is selected as the baseline project and appears in the first project column.
View charts from the collection
Using Group by with Line or Bar charts
Remove projects from the collection
To remove one or more projects from the collection, select the project's check circle and click
(Remove projects). This removes the projects from the collection, but not from Cortex.
Compare projects
- Select the check circle (first column) of each project you want to compare. To select all the projects in the list, click the check circle located next to the Project name column heading.
- Click
(Compare projects). - The Compare page opens showing the selected projects displayed side-by-side in a tabular layout with the project attributes in the first column. If all the projects contain 0 (zero) for a particular attribute, that attribute will not appear in the comparison.
Tip
You can drag and drop a project from your favorites or the clipboard to the Compare page. Cortex Project History adds the new project column to the end of the comparison.
Edit field values for multiple projects (bulk project editing)
- Select the check circle (first column) of all the projects you want to edit. To select all the projects in the list, click the check circle located next to the Project name column heading. If you don't select any projects, you will edit all of them.
- Click
(Edit projects) on the title bar. The Edit projects page opens. - On the Edit projects page, click Add change. The Add Change window opens.
- From the Field to edit list, select the field you want to modify.
- From the Values to replace list, select the value you want replaced.
- From the New value list, select the replacement value.
- To collect several changes, click Save & add to add the change to the Edit projects page and keep the Add Change window open so you can repeat this process to change the values for another field in the collection.
Otherwise, click Save & close to add the change and close the Add change window.
- When you are ready to update the projects with your changes, click Update on the Edit projectspage.
Tip
You can edit or delete a change before updating the projects by selecting the change and clicking Edit or Delete, respectively.
Cortex processes the field changes in the background. You can check the status of the project updates on the Project imports/updates page. Look for Edit projects in the Event type column.
If you open a project that is being processed (bulk project edits), Cortex notifies you that you will need to refresh the project to see the bulk edits when processing is complete.
View project locations on a map
In the title bar (the white area at the top of the Cortex window), click
to open a map showing the location of all the projects in the collection. The map works similar to Google Maps. For example, you can switch between showing satellite imagery and the street map. You can also drag Pegman onto the map to see the project site in street view.
- To open a popup showing more project details, hover over the project pin. Click the project pin if you want to keep it open.
- To open the project and see even more details, click the project name in the popup. The single project page opens in a separate browser tab.
How does Cortex determine the project location?
Cortex uses system fields to store a project's latitude and longitude. Anytime a project is imported, edited, or refreshed, the system checks the Address line field for a valid address or location to derive the latitude and longitude values. (Note that the administrator can set up an expression for the Address line field that concatenates your separate address fields (address, city, state, and zip) to form a complete address for mapping purposes. If desired, the project name field can be included in the expression too.) Entering a project-specific address in the Address line field will produce the best result for mapping.
If a valid address or location is not found in the Address line field, Cortex checks the Project location field to see if it can determine a latitude and longitude for the project.
When you use the project mapping feature, only projects that have latitude and longitude values appear on the map. The quickest way to populate the latitude and longitude fields for all your projects is to run the Refresh feature in the Administration module.
Select a baseline project
- Click the row circle to select the project.
- Click
. The baseline project moves to the top of the grid and is shaded orange.
As you scroll through the project rows, the baseline project remains visible at the top.
To replace the current baseline project, select the project you want to replace it with and click
.
To remove the baseline project selection, click
.
Show/hide outliers
Outliers indicate where your project data varies from the average or median by a certain percentage or standard deviation based on the outlier type you select. Outlier indicators display in project, element, item, and portfolio collections, and on the Compare projects page in Project History.
To show outliers in Cortex Project History
- Click
(Settings) in the top right corner of the collection or page. - Click Indicators in the list.
- In the Outliers window, move the Show outliers switch to the on position.
- Select the desired outlier type (Percentage or Standard deviation).
- For Percentage outliers, specify theStatistic basis(Average or Median) to use and the threshold percentages for the First and Second thresholds. The outlier arrow points up or down to indicate how it compares to the specified outlier type.
- Click Apply.
Tip
You can show/hide indicators in collections and the Compare projects page without changing the current indicator options in Settings by moving the Indicators switch (located in the top right corner of the page) to the on or off position.
Apply a different view to the grid
Modify the columns shown in the grid
You can specify which columns are visible and the column order for the project collection.
Change the column layout for the project collection
Select a different view
- In the collection title bar, click
(Settings). - Select the desired view from the list.
The name of the view currently in effect for the collection displays in the collection title bar (the white area at the top of the Cortex window).
If you make changes (resize a column, reorder the columns, etc.) to the view while working in the collection, an asterisk displays next to the view name indicating changes were made. Your changes are temporary and persist until you select a different view for the collection.
Modify the view
- Click
(Settings), located above the grid, and then click Settings from the drop down menu to open the Settings page. - On the Columns tab, the Selected list shows the columns that currently appear in the collection.
- To add a column, drag the desired column from the Available list and drop it in the Selected list. Expand and collapse column groups and use the Search box as needed to locate the desired column in the Available list.
- To remove a column, double-click the desired column in the Selected list. You can also select the column and click
on the selected column to remove it from the Selected list. - To change the column order, use drag-and-drop to rearrange the columns in the Selected list.
- Do the following to change the visible statistic rows (These rows help you analyze the totals for the projects. They are gray and appear at the top of the collection.):
- Click the Statistic rows tab located above the Available list.
- Move the desired statistic rows from the Available list to the Selected list to make them visible in the collection.
Ignore zeros in statistic values tip
The Ignore zeros option determines whether the statistic rows include or exclude projects that contain zeros. If a project in the collection contains a zero and is not applicable to your scenario, select the Ignore zeros option. However, if it does apply and you want it included in the Average and other statistic calculations, clear the Ignore zeros option.
Statistics always ignore null (blank) values. Depending on your suppression settings, some zero values can appear blank. You can download an import template for a project to see what values the fields actually contain.
Ignore baseline in statistic values tip
The Ignore baseline option determines whether the statistic values include or exclude the baseline project. Select this option to exclude the baseline project from the statistic values. Otherwise, clear this option to include the baseline project in the statistic calculations. This setting applies anywhere that statistics are visible in Cortex Project History.
- When you finish modifying the view, click Save.
Tip
After you modify the view, your changes persist between your Cortex Project History sessions unless you select a different view or save your changes to a personal view.
Resize columns
Click and drag the divider between columns to resize a column.
Change the column order
Drag the heading of the column you want to move and drop it in the desired position in the column heading row.
Save changes to a view
If you make changes (resize a column, reorder the columns, etc.) to the view while working in the collection, an asterisk displays next to the view name indicating changes were made. Your changes are temporary and persist until you select a different view for the collection.
- To save your changes to a personal view, click
(Settings) in the collection title bar (the white area at the top of the Cortex window), click Save view as, enter a view name in the Save View As window, and click Save. - When you change a shared view (the administrator manages shared views in the Administration module), you can save your changes to a personal view. This icon identifies shared views in the selection list:
Update multiple projects
This procedure is helpful when you want to update multiple projects in Cortex Project History.
- Open the desired project collection.
- Select all the projects you want to update.
- Click
(Download), and then click Download import template with data and select the desired template from the list; e.g., All fields. The Download Import Templates window opens. - Click Download to start the download process.
Cortex Project History downloads each project's data to an Excel file and opens each Excel file when the download is complete.
After you modify the project import templates, do the following to update the corresponding projects in Project History:
- Click Project imports/updates on the
menu. - Drag the Excel project import files and drop them on the Project imports/updates page.
The status of the imports displays in the grid at the bottom of the page.
The system performs minimum validation on the project import files to ensure that they use a valid template and contain the necessary data to work properly in Cortex Project History. For example, every project must have a project date and project location.
- Click Replace project to replace the existing project.Learn about the Project Replacement Warning
When a project ID in the import template matches a project ID in Cortex, the system warns you that the import process will replace the project with the project data in the import template. Your response to the warning determines whether the existing project is replaced or skipped during the import.
To apply your response to all matching projects found during the import process and dismiss all future project replacement warnings, select the Apply to all when importing multiple project updates check circle; otherwise, clear this check circle. When this option is selected, a yellow banner displays at the top of the Project imports/updates page alerting you that you opted to either replace projects or skip importing projects when the project ID matches and that all future project replacement warnings will be dismissed. This setting persists for all future project imports until you click the reset link in the banner.
- To replace the existing project, click Replace project.
- To skip the import for this project, click Skip.
Resize columns
Click and drag the divider between columns to resize a column.
Display individual factors in the collection grid
How does this work?
When you create a new rate table, Cortex Project History adds a project attribute for the table to the project field list. This attribute appears in the list of available fields (in the Factors group) for the project collection grid view, giving you the ability to display the factor in the project collection grid.
- Click
and select Administration from the menu to open the Administration module. - Click Views > Project collection > Grid views in the options list.
- Select the view you want to edit and click Edit.
- Drag the desired factors in the Factors group from the Available list to the Selected list to determine which factors display in the view.
- Drag the factors up or down in the Selected list to determine the order of the factors in the view.
- Click Save.
Export flat project data to Excel
Why would I want to export flat project data to Excel?
You can export flat data from the project collection (in grid view) to an Excel workbook so it is ready to be imported into reporting tools like Power BI or Tableau.
When Cortex flattens the project data, it removes the hierarchy from the data and creates one worksheet in the Excel workbook for each level in the data's hierarchy. For example, for MasterFormat, Cortex creates worksheets for Project, Group by Grand total, MasterFormat I, and MasterFormat II in the Excel workbook.
- Open a project collection.
- Click
in the title bar (the white area at the top of the Cortex window). - In the Export to Excel window, select the Export flat project data option.
- From the list, select the element view (e.g., Uniformat, MasterFormat) to use for the export.
- Click OK.
Cortex Project History exports the data to an Excel file and opens it when the export is complete. You can rename the file, if desired.
Export data from a grid to Excel
Expert tip
Many reporting tools, including Power BI, work with hosted storage services with synchronization functionality like Microsoft OneDrive. If you want to update a report regularly in Power BI or another reporting tool, you can save your workbook to a synced folder that works with your reporting tool.
For example, if you use Power BI, you can save the workbook to a synced OneDrive folder and import it into Power BI. If you update or replace the workbook in the synced OneDrive folder in the future, as long as the workbook retains its original name, Power BI and any reports that use the workbook automatically update with the new project data.
The
(Bulk project editing) and
(Subproject) features are not included in Cortex 365.