Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Jira automation of Original Estimates report

Hi everyone!


I need to create a report of Original Estimates given for tasks that are in an active state now, for each department we have in the company.

So, basically, I need to compare how many tasks overall we have and how many of them have original estimates.


Thank you in advance! 

2 answers

1 accepted

4 votes
Answer accepted
Mykenna Cepek
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Nov 23, 2021

I'd start by going into the "Issue" screen for any Jira project you have, and click on "Go to advanced search".

There you can use JQL to make custom searches across all issues in any of the projects in Jira. For example, searching for:

originalEstimate is not empty and statusCategory = "In Progress"

will give a list of all issues, in all projects, which are "active" and have an Original Estimate value. Note, that will probably be a LOT of issues. There are limitations on how many issues can be returned, and how many will be shown.

Note that the number of issues will be displayed after each search. So that's "the number of issues which have original estimates".

To discover "how many issues you have overall", remove the "originalEstimate is not empty and" clause.

You can restrict the results to a specific set of projects by adding something like this:

project in (Playground,Mykenna) and ...

In the resulting list of issues, you can use the "Columns" drop-down to adjust which fields are shown in the results. For example, you can show the "originalEstimate" field in the result.

Documentation about all the things you can do with JQL is here.

Once you have JQL that locates the issues of interest, consider making a shared Dashboard in Jira or maybe a page in Confluence, configured to use that JQL. That way, those who want this information can "self-serve" and look it up whenever they want it.

@Mykenna Cepek thank you for your answer, it was very helpful!

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 23, 2021

Hi @Olga Mocan  -- Welcome to the Atlassian Community!

You posted this question in the automation area, and I wonder if that is what you wanted.

To just list/count the issues you could either use a JQL query or create a dashboard to show the issues returned by the query.  If you needed this to occur repeatedly you may also "subscribe" to a save JQL query to have it email you on a schedule.

For example, you could use one query for all tasks for a department.  Let's assume you have a custom field called Department.  (Please change this and your project names and how you distinguish departments.)

project = myProjectName AND Department = myDepartmentName ORDER BY Key

To find the ones with an Original Estimate, just add that condition:

project = myProjectName AND Department = myDepartmentName AND originalEstimate IS NOT EMPTY ORDER BY Key


Kind regards,

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events