Time spent ratio

This template displays the time spent ratio of the current work item, i.e., the division of the time spent by the original estimate of the current work item multiplied by one hundred.

If the work item was not estimated or has no work logged, “None” will be displayed.

Configuration

To use the Time Spent Ratio template, simply select it from the template grid. Filter by KPI to find it faster.

Parameters

This template does not require any additional parameter configuration.

Expert mode

If you switch to Expert mode you can see the Smart field in the Expression Parser. You can now tweak the expression to create a custom smart field based on this template.

Expression

General expression:

CODE

%{%{issue.originalEstimate} != null AND %{issue.timeSpent} != null ? {issue.timeSpent} / {issue.originalEstimate} * 100 : null}

Format

Custom format

Pattern

Use the following pattern to return actual percentages, e.g. 75 %.

CODE

##.# %