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