How to calculate hours of issues in select customfield history

Hi EazyBi Community,

I am working on a report where I want to show history of an issue on a particular status. For example, we have a “Blocked” status in Jira workflow. An issue can be moved into “Blocked” status at multiple times and whenever the user moves an issue into the “Blocked” status he needs to select the “Blocking Reason” option(select customfield) and whenever the issue move back to the other statuses then blocking reason field gets clear.

Now, I want to show the history(no. of hours in blocked status) of an issue with the segregation of “Blocking Reason”.

Screen Shot 2020-12-19 at 5.48.31 PM

Can you please help me? i’ m very new to eazyBI

Hi @Gaurav_Sharma

Here you could try exploring our Javascript example “Days for assignee”

In your case, you would need to define the new calculated field and to look for “Blocking reason” field changes, and then map to the “Blocking Reason” dimension.

Unfortunately, we don’t have an exact example to share, and using MDX the calculation could be too complicated for the report, that is why we would recommend importing a precalculated field.

Martins / eazyBI support