Metrics for Features to inherit Planned Dates from User Stories and Bugs | Targetprocess - Visual management software

Metrics for Features to inherit Planned Dates from User Stories and Bugs

These custom formula metrics calculate planned dates for hierarchical entities.

Max Date value for a feature is calculated as max value across its nested user stories and bugs.

Max values are selected as max Planned End Dates [1].

Additionally, if you use Sprints / Releases / Team Iterations, you may set up custom calculations for user stories and bugs. Set calculated max date value for a user story and bug as max of its own Planned End Date and End Date of parent Sprint / Release / Team Iteration. [2]

Metrics for Features

Calculate Planned Date as max of planned dates of User Stories and Bugs.

Add 3 Date System custom fields to Feature entity.

Metrics for Features

Then configure 3 corresponding custom formula metrics.

Metrics for Features. Image 2

[1] Use these formulas if you inherit dates from planned dates of work items only.

Field NameField TypeCustom Formula Metric
US Max DateDate, SystemUserStories.MAX(PlannedEndDate)
B Max DateDate, SystemBugs.MAX(PlannedEndDate)
Max DateDate, System[beta] IIF(BMaxDate = null or USMaxDate > BMaxDate, USMaxDate, BMaxDate)

IIF(CustomValues.Date("B Max Date") = null or CustomValues.Date("US Max Date") > CustomValues.Date("B Max Date"), CustomValues.Date("US Max Date"), CustomValues.Date("B Max Date"))

[2] Use these formulas if you additionally inherit dates from Sprints / Releases / Team Iterations.

Field NameField TypeCustom Formula Metric
US Max DateDate, System[beta] UserStories.MAX(MaxDate)

UserStories.MAX(CustomValues.Date("Max Date"))

B Max DateDate, System[beta] Bugs.MAX(MaxDate)

Bugs.MAX(CustomValues.Date("Max Date"))

Max DateDate, System[beta] IIF(BMaxDate = null or USMaxDate > BMaxDate, USMaxDate, BMaxDate)

IIF(CustomValues.Date("B Max Date") = null or CustomValues.Date("US Max Date") > CustomValues.Date("B Max Date"), CustomValues.Date("US Max Date"), CustomValues.Date("B Max Date"))

Metrics for User Stories, Bugs

These metrics are required if you use Sprints, and you require to calculate custom Planned Date for User Stories and Bugs as max of own Planned End Date and Sprint End Date [2].

Add a Date System custom field to both User Story and Bug entity.

Metrics for User Stories, Bugs

Then configure related custom formula metric for these two entity types.

Metrics for User Stories, Bugs. Image 4

This example works for TeamIteration entity. Use references to Iteration, Release objects instead of TeamIteration object when required.

Field NameField TypeCustom Formula Metric
Max DateDate, SystemIIF(TeamIteration != null and (PlannedEndDate = null or TeamIteration.EndDate > PlannedEndDate), TeamIteration.EndDate, PlannedEndDate)

Additional Notes

Coming soon! In one of the next Targetprocess releases (v3.12.10+) it will be possible to refer to custom field vales by short alias labels. It won't be longer required to specify CustomValues.Type references. Remove spaces from field label to use it in custom formulas.

Math.MAX(a, b) method is not supported yet in custom formulas in Targetprocess. This is why IIF-based formulas are used instead.

Blank value cases must be checked and handled properly.

Still have a question?

We're here to help! Just contact our friendly support team

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.

Get Started for free

Enter your email
By clicking "Continue", you acknowledge that we will process your Personal Data in accordance with our Service Privacy Policy and Terms of Service, and agree to the aforementioned documents.

We’ve sent you a confirmation e-mail — please, go check it.

Or get a live
product demo