Report on EazyBI to show the total time that an issue is allocated to a particular group

Good morning community!

I hope you can help me

I need to create a report in eazybi that shows me the time in which an issue is assigned to a particular group.

When the issue is created, it is assigned to a work group and during the resolution process, this issue can be assigned to another group and then in turn can be re-assigned to the original group.

My requirement is to make a report that only shows me the total time in which that issue was assigned to a particular group and not the total time from when the issue was created to its final state.

Thank you in advance for your help.

Hi @Saul_Alexander_Mata,

In eazyBI, you may measure how much time issues were assigned to each assignee group using measures representing issue change history. Before going further, make sure you have imported issue history and dimension to represent Assignee Groups in eazyBI:

Then you may define a new calculated measure (in Measures) to go through all issues and for each issue calculate days between the transition to an assignee (or assignee group) and from an assignee (or assignee group). The formula might look like this:

  --filter a set of issues that changed assignee in a selected period
    [Measures].[Transitions from assignee] > 0 
  --for each issue calculate days between assignee changes
    --date when for the first time assigned to assignee or group
      ([Measures].[Transition to first timestamp],
      [Transition field].[Assignee],
      [Time].CurrentHierarchy.DefaultMember) ), 
    --date when for the last time assigned from assignee or group in selected period
      ([Measures].[Transition from last timestamp],
      [Transition field].[Assignee]) )

​For more details how to create calcaulted measures and used functions, see the docmentation:

Zane /

Hi @zane.baranovska
Thanks for your answer. I will try what you recommend.

I am trying to reproduce something similar using a select list field named ‘Assigned Queue’. As I’ve tried to set advanced settings to create the change log, I receive an error.

data_type = “string”
dimension = true
separate_table = true
changes = true

Execution of custom JavaScript code raised the following error:
ReferenceError: “jira” is not defined.

Can you please help?