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
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy