# Summary functions

You can use the following functions to create summaries for the dashboard.
###### Note

The following examples use US dollars.

Count
The number of times a data field contains a value.
In this example, Count = 4.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3
Project 4 \$49,000
Project 5 \$50,000
Skipped Count
The number of times a data field does not contain a value.
In this example, Skipped Count = 1.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3
Project 4 \$49,000
Project 5 \$50,000
Total Samples
The total number of projects that are scanned, or Total Samples = Count + Skipped Count.
In this example, Total Samples = 5.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3
Project 4 \$49,000
Project 5 \$50,000
Grouped Count
The number of times a list field contains the same value. This function applies only to list fields.
In this example, Grouped Count is:
• 30% = 3
• 40% = 1
• 80% = 1
Project % Complete
Project 1 40%
Project 2 30%
Project 3 80%
Project 4 30%
Project 5 30%
Sum
The result of adding all values for a data field.
In this example, Sum = \$243,500.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000
Mean
The sum of all values for a data field, divided by the total number of projects scanned, or Mean = Sum / Count.
In this example, Mean = \$48,700.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000
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.
In this example, Median = \$49,000.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000
Minimum
The smallest value for a data field in a group of projects.
In this example, Minimum = \$47,500.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000
Maximum
The largest value for a data field in a group of projects.
In this example, Maximum = \$50,000.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000
Standard Deviation
The spread of the data from the mean expressed in the same units as the data.
In this example, Standard Deviation = \$975.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000
Variance
The spread of the data from the mean.
In this example, Variance = \$950,000.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000
Range
The difference between the largest and smallest values for a data field in a group of projects.
In this example, Range = \$2,500.
Project Savings
Project 1 \$47,500
Project 2 \$48,000
Project 3 \$49,000
Project 4 \$49,000
Project 5 \$50,000