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

[Niels Finkenflugel]

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?

[Yuliia_Borivets__SaaSJet_]

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.

[Niels Finkenflugel]

Nice, I will look into this

[Nic Brough -Adaptavist-]

Find or write a report that looks at the history.

JQL is not reporting, all it does is give you a list of issues that match the criteria you give it.

It is up to the reporting function to extract the data you want to see from the returned issues.

The issue navigator is the report you get when running JQL, and that is quite simple, in that it shows you the issues you asked for as they are at the time you run the search.

[Niels Finkenflugel]

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.