Before you create a global data field, consider how you want to view the data in dashboard reports.
Single-value data is data that has only one value per project. For example, use a single-value data field to collect a project's location, owner, or business unit. On the dashboard, single-value data is summarized in graphs and tables.
Data tables contain multiple data points for a single project. For example, use a data table to collect financial data, team members, or tasks. On the dashboard, data from a data table is displayed differently in column sets depending on whether the report is based on projects or tasks. Project reports display data from a data table as a link in a column set. Task reports display data from a Tasks data table as individual rows in a column set.
Managed data for projects refers to critical data, such as financial or savings data, that is specific to a single project. This data is often stored and controlled by users with elevated permissions who are external to the project. To use managed data for a project in dashboard reports, a data architect must first create a table for it in the sandbox. After the table is created and published to the live site, a data manager can import managed data from the Data page in the web app. For information about how to create at a table for managed data, go to Create a table for managed data. For information about how to import managed data, go to Import managed data.
In the dashboard, counts are unique variables that use key date fields, such as Start Date or Due Date, to determine the number of projects or tasks within a specific time interval. For example, you might use the count called Number of Projects Completed, which uses Completion Date to determine the number of projects completed by month, by quarter, this year, and so on.
You can create a new count based on a date field or a formula field that uses date values. You can also change the name or the associated date for existing counts. Counts are only available in dashboard reports. You cannot add them as data fields in form templates.
Data fields belong to either single-value categories or data tables. Before you create or edit a data field, decide whether to add the data field to a single-value category or a data table. For more information, go to What is a data field?.
To prevent this example from affecting the live site, discard any changes before you exit the sandbox.
When you add a list of values, keep Include a blank option selected to ensure accurate report results if a list value is deleted. For more information, go to Effects of deleting global data.
To edit a global data field, you can select its edit button or you can search for it.
To prevent this example from affecting the live site, discard any changes before you exit the sandbox.
When you edit a list field, do not delete existing list values. Instead, make the value inactive. For more information, go to Effects of deleting global data.