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

Question

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.

marcelalexandre26 · Answer

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.

Lauma Cīrule · Answer

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

marcelalexandre26 · Answer

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.