A calculated number metric is a metric that is generated from a data source in the project. The data source can be a list (an entire list, a view in a list or a list filtered by your own custom CAML) or it can be a BrightWork Reporter report.
Example: Issues. This metric counts the number of Issues with a Red Status Indicator. This metric is available in the Project Lite, Project Standard and Project Structured templates.
See Supplied Metrics for more metric examples. Most of the supplied metrics are actually calculated number metrics.
To create a calculated number metric:
The system will automatically generate a Metric ID for the metric using the title, but you may update to one that makes more sense to you.
If the Metric ID already exists in the list, you will see a message saying that 'the Metric ID is not available' when you attempt to save it or click the Check button. This means you will have to edit so that it is unique.
Making the Metric inactive does the following:
The available options include:
If the view has item limits enabled, the metric will only use the items returned.
If the items in the view are grouped into batches, the metric will use all the items returned by the view in all the batches.
You must select a report which does not include report filter(s).
Reports that include report filters (e.g. My Work, Work Due Soon) are not supported as a Metric Data Source. Selecting such a report will cause a warning message to display and you will be unable to save the metric.
Note: The following characters are supported for number columns - "."; ","; "#","%","0".
The "#" character is used to describe integers. The "." and "," characters are used to describe the location and type of punctuation. The "0" character is used enforce digits before and after the "." character.
An example of their use:
The number 5351 would be displayed in reporter using the following display format - "#,###"- as "5,351".
See Custom Number String Examples for more examples.
Note: When Lower values are better is selected, a value above the specified thresholds will trigger an indicator.
When Higher values are better is selected, a value below the specified thresholds will trigger an indicator.
Note: When Lower values are better is selected, the Warning Level must be less than the Danger Level.
When Higher values are better is selected, the Warning Level must be greater than the Danger Level.