report : signed, spent and remaining time on a specific period


I would like create a report on a specific period with a start date and an end date, or weekly or monthly.

On this period I would like know :

  • the signed time (original estimate)
  • the time spent (including subtasks)
  • the remaining time (including subtasks)

I try to perform that with All-In-One JIRA Reports plugin without success. So please tell me if you know how do that or if I have to install an other plugin or for all other technique.

Thank you for your help.


2 answers

Hi Alexandre,

Please take a look at eazyBI report creation add-on for JIRA. With eazyBI you can create custom reports based on JIRA data.

Here is an example report that shows Original estimated hours, Hours spent and how many hours were remaining by the end of selected time period. You can select on what time you wish to see data in Time dimension / All hierarchy level members. Also, I have added a filter to the time by clicking on x-axis. 

Let me know if you have any questions regarding eazyBI!

Kind regards,
Lauma / 


Thank you for your answer Lauma.

I try yet eazyBI plugin but I have some problems. Firstly, I would like for the original estimated hours the variation between two mounth. In your example, in February it worth 71.5h and in March 199h, so I want for March 199-71.5 = 127.5h and not 199h.

Furthermore, for the original estimated hours the value correspond to the first date I specify an original estimated hours. If I modify it after, that continue to take the first date and not the modification date.

Concerning the remaining hours, if I make a work at another date than today, that will not take specified date but today date.


Thank you for your help.

Hi Alexandre,

The Original estimated hours on timeline are grouped based on Issue creation date (see 

So, in the example, there are several issues created in February with total original estimated hours of 71.5h. For the issues created in March the total original estimate is 199h. The March estimate does not include issues that were created in February. Nevertheless, you could calculate the variance with following calculated member 

[Measures].[Original estimated hours] -
([Time].CurrentHierarchy.PrevMember, [Measures].[Original estimated hours])

Also, we do not currently import the Original estimated hours change based on the date it is changed. If the Original estimate is changed, it shows the new value as originally estimated on timeline whenever issue was created.
But it would be possible to import the original change with custom JavaScript calculated member. If you would need assistance with this, please let me know more details of how you would like to show this - continuous line of Original estimate changing over time or how much Original estimate was on the first date it was specified, and how much it is on the date it was changed.

Kind regards,
Lauma / 

Original estimated hours change problem is fixed, thank you.

Concerning, original estimated hours modification date, I will look JavaScript calculated member.

Concerning remaining estimated hours date at work date, it's also possible with JavaScript calculated member ?

Thank you for your help.

Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

129 views 3 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot