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:
%{%{issue.originalEstimate} != null AND %{issue.timeSpent} != null ? {issue.timeSpent} / {issue.originalEstimate} * 100 : null}
Display as
Number
Formatting style
Custom pattern
Pattern
Use the following pattern to return actual percentages, e.g. 75 %.
##.# %