Custom field value report with specific state transition start date

[gerda.grantina]

Hi @HgNeoh ,
If you have the field in Jira as number type, then select in eazyBI account import setting to import this field value changes as well:

It will create a measure “Time consumed history” that you can use in your calculations.
Based on this community post you can create a similar formula to get the historical data from your field on a particular day when the issue transitioned to another status:

Get a value of Remaining Estimated Hours measure form specific date

Hi @elopezz Welcome to the eazyBI community! You may want to use the measure “Remaining Estimated Hours history” to retrieve a remaining estimate at the end of a particular date. And function DateMember() to get the Time dimension Day level member of the transition: MDX Function Reference Puttin it together, you would get a tuple: ( [Measures].[Remaining estimated hours history], [Time].[Day].DateMember( ([Measures].[Transition to status first date], [Transition Status].[Ready], [Time]…

And if you want to sum the result, then you can create this formula:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
      ([Measures].[Transition to status first date],
      [Transition Status].[In Progress],
      [Time].CurrentHierarchy.DefaultMember)),
      [Time].CurrentHierarchyMember
    )
  ),
  (
  [Measures].[Time consumed history],
  [Time].[Day].DateMember(
   ([Measures].[Transition to status first date],
    [Transition Status].[In Progress],
    [Time].CurrentHierarchy.DefaultMember))
  )
)

Keep in mind, that the “Assignee” dimension is linked to historical data, thus it means that the results will be summed by assignees who were on the date when the issue transition happened.

best,
Gerda // support@eazyBI.com