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.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3  
Project 4 $49,000
Project 5 $50,000

Count = 4

Skipped Count

The number of times a data field does not contain a value.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3  
Project 4 $49,000
Project 5 $50,000

Skipped count = 1

Total Samples

The total number of projects that are scanned.

Total Samples = Count + Skipped Count

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3  
Project 4 $49,000
Project 5 $50,000

Total samples = 5

Grouped Count

The number of times a list field contains the same value.

Note

This function applies only to list fields.

Project % Complete
Project 1 40%
Project 2 30%
Project 3 80%
Project 4 30%
Project 5 30%
Grouped count:
  • 30% = 3
  • 40% = 1
  • 80% = 1

Sum

The result of adding all values for a data field.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

Sum = $243,500

Mean

The sum of all values for a data field, divided by the total number of projects scanned.

Mean = Sum / Count

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

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.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

Median = $49,000

Minimum

The lowest value for a data field in a group of projects.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

Minimum = $47,500

Maximum

The highest value for a data field in a group of projects..

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

Maximum = $50,000

Standard Deviation

The spread of the data from the mean expressed in the same units as the data.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

Standard deviation = $975

Variance

The spread of the data from the mean.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

Variance = 950,000

Range

The difference between the largest and smallest values for a data field in a group of projects.

Project Savings
Project 1 $47,500
Project 2 $48,000
Project 3 $49,000
Project 4 $49,000
Project 5 $50,000

Range = $2,500

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy