Skip to main content
Skip table of contents

Bundled Formulas

The simplest way to include formulas in a structure is to use one of our bundled formulas.

To add a bundled formula, click the + button to the right of the column header and scroll down until you locate the CALCULATED section.

The following predefined formulas are available:


Column NameDescription
BugFix % (Count)Displays the percentage of bugs among all sub-issues. Bugs are identified by having issue type "Bug".
BugFix % (Time)Displays the percentage of time scheduled and spent on bugs, compared to the time scheduled and spent on all sub-issues. Uses Jira time tracking fields.
Due InDisplays the amount of calendar time left before each issue's Due Date.
Linked IssuesLists all issues that are linked to the current issue and their link types. If the status category of a linked issue is Done, its issue link is crossed out.
Open BlockersDisplays all issues that block the current issue and are unresolved.
RICE

RICE is a scoring model used to prioritize features.

The RICE score is calculated based on the following formula:

Reach x Impact x Confidence / Effort

  • Reach – How many people will the feature affect over a given period?
  • Impact – How much will this benefit the users or your goal?
  • Confidence – How confident are you in the numbers above?
  • Effort – How much work will be required to complete the feature?

Learn more: RICE Formula Preset

To use this formula, you must set up custom number fields for Reach, Impact, Confidence, and Effort.

Time Since Last UpdateDisplays the amount of calendar time that has passed since the issue was last updated.
Time to ResolveFor resolved issues, displays the amount of calendar time that passed between issue creation and its resolution.
Total UnderestimationDisplays the percentage by which the total actual time expenditure exceeded the total original estimate. Uses total Time Spent and Remaining Estimate fields to calculate the actual time. This "Totals" formula uses the SUM function to calculate a value for the issue and all its sub-issues.
Total Work Ratio (Points)Ratio of total work done to the total amount of work. The amount of work is counted in Story Points, and issues are considered "done" when they have a non-empty Resolution field. This "Totals" formula uses the SUM function to calculate a value for the issue and all its sub-issues.
Total Work Ratio (Time)Ratio of total work done to the total amount of work. The amount of work is based on the sum of Time Spent and Remaining Estimate values. This "Totals" formula uses the SUM function to calculate a value for the issue and all its sub-issues.
WSJF (Basic)Weighted Shortest Job First metric, based on basic attributes available in any Jira – Priority, Votes, Watchers, Due Date, Story Points and Remaining Estimate.
WSJF (SAFe)

Weighted Shortest Job First metric, based on recommendations from Scaled Agile Inc. To use this formula, you must set up the following numerical fields:

  • Job Size
  • User/Business Value
  • Time Criticality
  • Risk Reduction
  • Opportunity Enablement

If you have such fields but they are not numeric (for example, a select list), edit the formula and replace the usage of a variable with a CASE() function, where you can assign individual numerical weights to each option.

WSJF (Tempo)

Weighted Shortest Job First metric, according to categories used at Tempo:

  • Benefit
  • Pain
  • Marketability
  • Impact
  • Cost
  • Risk
  • Clarity

To use this formula, you must set up such fields with the following values: Nil, Low, Medium and High.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.