A variable in this category counts the number of projects included in the dashboard. The Number of Projects variable counts projects regardless of date. It is not an event. An event is a variable that is used to count the occurrence of datebased events. For example, the Number of Projects Started counts the number of projects that have a Start Date in the specified period of time.
Use the Number of Projects variable with grouping variables to count projects with specific characteristics, for example, Number of Projects by Location and/or Project Type.
Variables that have only one value per project. For example, a project can have only one value for Location, or a project can have only a single calculated value for Project Duration.
Variables that include one or more rows of data per project. For example, the variable Hard Savings in the Financial Data TimeOrdered category has 12 rows of monthly hard savings data.
If you select a variable that is not compatible with any of the previously selected variables, Companion adds the selected variable and removes the variables that are not compatible.
Variable  Compatibility 

Number of Projects variable  Not compatible with any other variables 
Events  Compatible only with other events 
Multipleentry variables  Compatible only with multipleentry variables in the same category 
Singlevalue variables  Compatible only with singlevalue variables 
You can use the following functions to create summaries for the dashboard.
Function  Description  Example  

Count 
The number of times a data field contains a value. 
Count = 4 

Skipped Count 
The number of times a data field does not contain a value. 
Skipped count = 1 

Total Samples 
The total number of projects that are scanned. Total Samples = Count + Skipped Count 
Total samples = 5 

Grouped Count 
The number of times a list field contains the same value. NoteThis function applies only to list fields. 
Grouped count:


Sum 
The result of adding all values for a data field. 
Sum = $243,500 

Mean 
The sum of all values for a data field, divided by the total number of projects scanned. Mean = Sum / Count 
Mean = $48,700 

Median 
The middle value for a data field in a group of projects. For an even number of projects scanned, the median is the average of the two middle values. 
Median = $49,000 

Minimum 
The lowest value for a data field in a group of projects. 
Minimum = $47,500 

Maximum 
The highest value for a data field in a group of projects.. 
Maximum = $50,000 

Standard Deviation 
The spread of the data from the mean expressed in the same units as the data. 
Standard deviation = $975 

Variance 
The spread of the data from the mean. 
Variance = 950,000 

Range 
The difference between the largest and smallest values for a data field in a group of projects. 
Range = $2,500 