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

Hello,

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

This widget could not be displayed.

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 / support@eazybi.com 

This widget could not be displayed.

Hi,

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 https://docs.eazybi.com/display/EAZYBIJIRA/Data+model#Datamodel-Measures). 

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 / support@eazybi.com 

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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

171 views 18 7
Join discussion

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