Original estimated hours weekly distribution based on start and end dates

Questions & Answers
1

Hello All,

I wanted to see Original estimated vs Hours spent on a weekly basis. However, Original Estimated hours are based on Issue created. Please help.

2

I think you should add project in page an time in row. fom hierarchy level member select week.
then define new calculated member with the folowing formula :
[Measures].[original estimated hours]/ [Measures].[Hours spent]

3

Hi @ahmedqureshij,

You are correct. The “Original estimated hours” measure is tied to the Time dimension on the issue creation date and “Hours spent” when the work was logged.

I recommend using the “Remaining estimated hours history” measure instead of “Original estimated hours”. It will display the amount of work still remaining at the end of each week based on your estimates and work logged in those issues.

Then you can compare the remaining estimate of the previous week to the current week’s hours spent. The formula could look similar to the one below:

CASE WHEN
  ([Measures].[Remaining estimated hours history],
  [Time].CurrentHierarchyMember.PrevMember) > 0
THEN
  [Measures].[Hours spent]
  /
  ([Measures].[Remaining estimated hours history],
  [Time].CurrentHierarchyMember.PrevMember)
END

If the above doesn’t fit your requirement, please elaborate on how you want to tie the original estimate and hours spent to start and end dates. How and where are these dates defined?

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com

4

Hello Roberts,

Thanks for the reply, i am actually looking more from a capacity perspective. For instance,
Task created on 1st Jan with - Dates- 1st Jan 2023 to 10th Jan 2023- Original estimated hours - 100, i wanted to check on 5th Jan 2023, what is my expected estimated hours and how many hours i have burnt.
Currently Original estimated hours will be shown only against 1st Jan on 5th Jan it will be 0. Remaining estimated hours will give us hours based on time spent, however i want Planned or Expected hours as of status date

5

Hi @ahmedqureshij,

Thank you for clarifying. My understanding is that you have a particular period selected in the Time dimension in pages and view the individual “Day” level members in report rows. To calculate the total Original estimate created in the visible period, you can use the calculated measure formula below:

Sum(
  VisibleRowsSet(),
  [Measures].[Original estimated hours]
)

The report then could look similar to the one below:

Screenshot 2023-08-15 at 16.57.36
Screenshot 2023-08-15 at 16.57.361410×1234 125 KB

Alternatively, if you want to see the cumulative sum, you can use standard calculations for the “Orignal estimated hours” measure - Create reports.

Best,
Roberts // support@eazybi.com