Fields Glossary

The table below contains only a very limited short list of selected fields, which needed additional clarification. The full list of fields available within the add-on is much larger. In case of any questions regarding any field, please contact Support.

#

Field Name

Formula

#

Field Name

Formula

1

Age (Business days since creation)

Total number of days, excluding Saturdays and Sundays, between "Current Time" and Issue's "Created" date time

2

Age (Calendar days since creation)

Total number of days, including Saturdays and Sundays, between "Current Time" and Issue's "Created" date time

3

Business days since last update

Total number of days, excluding Saturdays and Sundays, between "Current Time" and Issue's "Updated" date time

4

Calendar days since last update

Total number of days, including Saturdays and Sundays, between "Current Time" and Issue's "Updated" date time

5

Days to Resolve (Business)

Total number of days, excluding Saturdays and Sundays, between Issue's "Created" date time and Issue's "Resolved" date time

6

Days to Resolve (Calendar)

Total number of days, including Saturdays and Sundays, between Issue's "Created" date time and Issue's "Resolved" date time

7

Effort Variance

"Time Spent" + "Remaining Estimate" - "Original Estimate"

8

Effort Variance (Incl. Sub-tasks)

"Time Spent (Incl. Sub-tasks)" + "Remaining Estimate (Incl. Sub-tasks)" - "Original Estimate (Incl. Sub-tasks)"

9

Percent Complete

"Time Spent" * 100 / ("Time Spent" + "Remaining Estimate")

10

Scope Change %

("Time Spent" - "Original Estimate") * 100 / "Original Estimate"

11

Scope Change % (Incl. Sub-tasks)

["Time Spent (Incl. Sub-tasks)" - "Original Estimate (Incl. Sub-tasks)"] * 100 / "Original Estimate (Incl. Sub-tasks)"

12

Projected Scope Change %

("Time Spent" + "Remaining Estimate" - "Original Estimate") * 100 / "Original Estimate"

13

Projected Scope Change % (Incl. Sub-tasks)

["Time Spent (Incl. Sub-tasks)" + "Remaining Estimate (Incl. Sub-tasks)" - "Original Estimate (Incl. Sub-tasks)"] * 100 / "Original Estimate (Incl. Sub-tasks)"

14

Estimate at complete

"Time Spent" + "Remaining Estimate"

15

Estimate at complete (Incl. Sub-tasks)

"Time Spent (Incl. Sub-tasks)" + "Remaining Estimate (Incl. Sub-tasks)"

16

Time entry Date

The date for which the time was logged. For example, if a user logs 10 hours for 2018-Sept-24 (Monday), but the time was logged on 2018-Sep-28 (Friday), then Time Entry Date = 2018-Sept-24 and Worklog Creation Date = 2018-Sep-28

17

Worklog Creation Date

The date on which the time was logged. For example, if a user logs 10 hours for 2018-Sept-24 (Monday), but the time was logged on 2018-Sep-28 (Friday), then Time Entry Date = 2018-Sept-24 and Worklog Creation Date = 2018-Sep-28

18

Issue Effort > Time Spent

Total time logged on the issue. It is the sum of time from all the worklogs entered on that issue. Individual worklog time is reported via "Time entry: Logged time" field which is described next. 

Time Spent = Sum(Time entry: Logged time)

19

Time Tracking (Worklogs) > Time entry: Logged time

This field represents the time logged in each worklog entry. For example if time has been logged as follows on an issue: 

1 Feb 2019, 1hr, User A

2 Feb 2019, 2hr, User A

3 Feb 2019, 3hr, User A

1 Feb 2019, 1hr, User B

2 Feb 2019, 2hr, User B

3 Feb 2019, 3hr, User B

The dates (1 Feb, 2Feb, 3Feb) are represented by- "Time Entry: date" field

Hours (1hr, 2hr, 3hr) are represented by- "Time entry: Logged time" field

Users (User A, User B) are represented by- "Time entry: User" field

This aggregate value of hours on the issue (12 hours in this example) is stored by Jira on the issue in "Time spent" field which is represented by "Issue Effort > Time Spent" field.

Time Spent = Sum(Time entry: Logged time)