Help with Original Estimate

Questions & Answers
1

Hello,

I have a report which is supposed to display the plan line based off of the Jira original estimate. To do this, I need the original estimate of the issue (including subtasks). This is the formula I am currently using, but it is the source of a performance bottleneck (I am presuming because I have to go back in history). Is there a better way to accomplish the same thing here? I need the value to be available to my other calculations.

-- The number of original estimated hours accumulated to this point.
-- This is used to support the Work Planned measure.
Cache(
  NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
    [Measures].[Original estimated hours with sub-tasks]
  ))
  + [Measures].[Original estimated hours with sub-tasks]
)
2

Can any body offer any advice?

3

Hi @maleport,
From the first look, it doesn’t seem that the formula itself should be a bottleneck. It might be because of the report context - what information is in Rows, Columns, Pages, what other measures you are using in the report context?
For further investigation could you please export and share the definition for your eazyBI report?
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions. Please send it to support@eazybi.com.

best,
Gerda // support@eazyBI.com

4

Thank you for the reply Gerda! This is what I have configured currently.

eazyBIReport2
eazyBIReport2276×887 17.2 KB