A calculated date 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: Time. This metric calculates the Project estimated Current Finish Date. It is also used to indicate if a project is late, in danger or on target. This metric is available in the Project Lite, Project Standard and Project Structured templates.
See Supplied Metrics for more metric examples.
To create a calculated date 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:
Note: 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.
Note: 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.
The Metric Indicator setting allows you compare the Metric value to a target and specify Warning and Danger parameters to trigger associated icons.
When Earlier dates are better is selected , any Metric date before the target will trigger the default green icon. A Metric date one day after the target value will trigger the Warning icon. A Metric date two or more days after the target value will trigger the Danger icon. In other words, the further away we move from a date in the past, the worse it is. This is the setting you will probably use in the majority of situations.
When Later dates are better items is selected, any Metric date on or after the target will trigger the default green icon. A metric date one day before the target value will trigger the Warning icon. A metric date two or more days before the target value will trigger the Danger icon. In other words, the closer we get to a future date, the better it is and the further away from a future date, the worse it is.
Note: The number of days must be a whole number between 0 and 10000.
The Danger value must be greater than or equal to the Warning value.