How to retrieve the "Remaining Estimate" of an issue for a given date/time?

Question

For analysis, I would like to be able to retrieve the value of the 'Remaining estimate' field for a set of issues for a given moment in time. The idea is to be able to analyze the delta of total remaining estimate (of multiple issues) of a given time x with a given time y.

An example query to retrieve the tickets for a given moment in time:

project = Bonn AND sprint = 22.42 AND status was in (Open, Blocked, "In Progress", Resolved, Closed) ON "2022/10/14"

The 'problem' is that the search results show the actual remaining estimate (so the latest status) and not the remaining estimate that was valid on that day.

In this case, the ticket was created on the 14th with an original estimate of 2 hours. The remaining estimate is the same as there was no work performed yet. When running the query today (1 week later) the above query results in showing a remaining estimate of 1h because there was work logged on the 20th.

My expectation is that the JQL would output a remaining estimate of 2h as this was the case on the 14th.

How to address this?

Niels Finkenflugel · Answer

Nice, I will look into this

Niels Finkenflugel · Answer

That makes sense! It is possible to create your own reports? So far I find most of the standard reports not very useful but also have not found a way of creating my own.

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Niels Finkenflugel

You can create this kind of report with Issue History for Jira if you are ok with add-ons. My team developed it to get a changelog of any field for the list of issues.

For your report, you need to:

1. Filter issues by Project, Sprint, Assignee, etc.

2. Choose the date range you need.

3. Add "Remaining Estimate" or other issue fields you want to monitor changes about. Use Column manager for this option.

Here is a 30-day trial to check if the app is good for you.