Data Types

Custom Formula Metrics

Custom Formula Metrics can set values to the custom fields of the following types: Number, Text, Date, Check Box, Drop Down List, Template URL, Money, Targetprocess Entity.

๐Ÿšง

Type of calculation result must match type of target Custom Field

Apply type conversion operators to your formulas when result type does not match field type.

Calculated Custom Fields

Calculated Custom Fields (CCF) can have one of the following result type: Number, Text, Date and CheckBox.

Targetprocess determines final result type automatically. You don't need to care about it. Initially you create a custom field with common Calculated type for any result type. The final result type is shown in Type column in the list of custom fields.

How to work with supported data types

Number

Set integer or decimal values to Number custom fields. Set 0 as default value. Cannot set blank value. Both positive and negative values are supported. Precision for fractional values is up to 2 decimal places.

Examples:
Number custom field for a feature. Calculates count of nested user stories.
Number custom field for a user story. Calculates effort of related bugs.

Formula syntax is the same for Custom Formula Metric and Calculated Custom Field:
UserStories.Count
Bugs.SUM(Effort)

Text

Set String values to Text custom fields. Set null as blank value.

Example:
Text custom field for a user story. Calculates name of parent epic.

Formula syntax is the same for Custom Formula Metric and Calculated Custom Field:
Feature.Epic.Name

Date

Set Date values to Date custom fields. Set null as blank value.

Example:
Date custom field for a feature. Calculates earliest start and latest end date of nested user stories. Dates are retrieved from the team iterations that contain the stories.

Formula syntax is the same for Custom Formula Metric and Calculated Custom Field:
UserStories.MIN(TeamIteration.StartDate)
UserStories.MAX(TeamIteration.EndDate)

Check Box

Set Boolean values to Check Box custom fields. Default value is False.

Example:
Check Box custom field for a user story. Check if a story has nested tasks and bugs. Set to true if there is at least one task or bug, false otherwise.

Formula syntax is the same for Custom Formula Metric and Calculated Custom Field:
Tasks.Count + Bugs.Count > 0

Drop Down List

Set String values to Drop Down List custom fields. Set null as blank value. Fields of this type can be set by Custom Formula Metrics only.

Example:
Drop Down List custom field for a user story. Calculate t-shirt estimated size of the story based on its effort. Set 'S' if effort is 1..2, set 'M' for 3..7, set 'L' for 8 and greater. Keep the field blank when no Effort is set. A user can set t-shirt estimated size to a story manually even when no exact numeric value for an effort is provided yet.

Formula syntax for Custom Formula Metric:
IIF(Effort == 0, null, IIF(Effort < 3, "S", IIF(Effort < 8, "M", "L")))

Multiple Selection List

Set String values to Multiple Selection List custom fields. To select multiple values provide comma-separated list of them. Set null as blank value. Fields of this type can be set by Custom Formula Metrics only.

Example of the output values that can be set:
"Value A"
"Value B,Value C"
"Value A, Value C"
null

Template URL

Set String values to Template URL custom fields. Set null as blank value. Fields of this type can be set by Custom Formula Metrics only.

Money

Set integer or decimal values to Number custom fields. Set 0 as default value. Cannot set blank value. Both positive and negative values are supported. Precision for fractional values is up to 2 decimal places. Fields of this type can be set by Custom Formula Metrics only.

Targetprocess Entity

Set integer (numeric) values to Targetprocess Entity custom fields. Pass numeric ID of an entity to set a link to it. Fields of this type can be set by Custom Formula Metrics only.

The metric can set a link to a blank field or can replace existing link with another one. The metric can set a field to a blank value only when a reference to a non-existing entity is provided. 0 does not reset a field to a blank value.

Example:
Targetprocess Entity custom field for a user story. Inherit direct link to a parent epic.

Formula syntax for Custom Formula Metric:
Feature.Epic.ID

๐Ÿ“˜

Not supported field types

  • Rich Text
  • URL
  • Multiple Targetprocess Entities