How to calculate the time an issue spend with the priority = Blocked

[Luiza Silva]

Hi,

In some projects, we use the field "priority" to manage the issues that are blocked.

I want to know how many days an issue has the priority = "blocked".

Is there any way to get this information with jira or eazybi?

Thanks,

Luiza

[Eugenio Onofre · Accepted solution]

@Luiza Silva

You can achieve it by using the "Time in Status" gadget on the Jira Dashboards. To do so, you have to create a filter or project and link it to your dashboard gadget.

Another option would be to look into some Marketplace plugins, such as https://marketplace.atlassian.com/apps/1211756/time-in-status?tab=overview&hosting=cloud

Regards!

[Roberts Čāčus - eazyBI]

Hi @Luiza Silva ,

You can retrieve the duration an issue has been in a particular Priority in eazyBI with a calculated measure. The calculation would look at the transition dates in the Priority field for the particular value.

If you want to see the duration for individual issues, I recommend using the Issue dimension in report rows. First, to see only relevant issues, define a calculated measure that would return the number of transitions to the particular Priority. The formula could look similar to the one below:

([Measures].[Transitions to],
[Transition Field].[Priority],
[Priority].[Blocked])

You can add the measure to the report and then filter the report rows by it. Next, define a calculated measure to retrieve the duration with the particular Priority. See the suggested formula below:

IIf(
  -- issue still in the Priority?
  [Measures].[Issue priority] = 'Blocked',
  -- duration till now or resolution date
  DateDiffDays(
    TimestampToDate((
      [Measures].[Transition to last timestamp],
      [Transition Field].[Priority],
      [Priority].[Blocked],
      [Time].CurrentHierarchy.DefaultMember
    )),
    CoalesceEmpty(
      [Issue].CurrentHierarchyMember.Get('Resolved at'),
      'today'
    )
  ),
  -- duration till transitioned out
  DateDiffDays(
    TimestampToDate((
      [Measures].[Transition to last timestamp],
      [Transition Field].[Priority],
      [Priority].[Blocked],
      [Time].CurrentHierarchy.DefaultMember
    )),
    TimestampToDate((
      [Measures].[Transition from last timestamp],
      [Transition Field].[Priority],
      [Priority].[Blocked],
      [Time].CurrentHierarchy.DefaultMember
    ))
  )
)

The report then could look similar to the one below:

Please see the eazyBI documentation page for more details on defining calculated measures and filtering report rows.

Best,

Roberts // support@eazybi.com

[Bharathi]

Agreed with @Eugenio Onofre's solution of using "Time in Status" plugin. 

@Luiza Silva, for your scenario of using a field to indicate the blocked status and to find the duration of the issue in that status, the aforesaid plugin is a boon. It has options to filter out issues based on a user/project/JQL filter/sprint/custom JQL. Once the required issues are filtered out using a JQL, we can view the different options like status duration/ duration between statuses/ reports based on assignee or group or count or date.

Hope this helps!

Thanks!