How to count defects inflow to agile teams in easyBI report and JQL query

[Aboobacker Siddiq]

Hi All,

I am new with eazyBI.

In my project, we have multiple agile teams, Team 1, Team 2, and Team 3, and use the JIRA field "Agile Team" under the Assignment section to assign agile teams.

In the eazyBI report measured weekly, I want to count the defects that are inbound to each agile team.
Ex.
Team2 => Team1 or Team3 => Team1

I need the support of JIRA experts, Based on "Agile Team" changes, how to get defects inflow count in eazyBI report via MDX query and JQL query.

Thanks in advance for your valuable feedback.

[Zane eazyBI Support]

Hi @Aboobacker Siddiq

In eazyBI, you can import the change history of the single select custom fields. If the "Agile Team" is a single-select custom field, then this is how to do it.

1. First, import the change history for the "Agile Team" custom field.
Go to import options, tab Custom fields, and mark "Import value changes" for the custom field "Agile Team" and Import data.

If you do not see the option "Import value changes", you can edit the field "Agile Team" advanced settings and enable it. Add parameters:

separate_table = true
changes = true

Now you can mark “Import value changes” for the custom field "Agile Team" and Import data.

For more details, please see the documentation: https://docs.eazybi.com/eazybi/data-import/data-from-jira/import-issue-change-history#Importissuechangehistory-Customfielddimensions.

2. In the report, you may define a calculated measure to look at the change history for the "Agile Team". For calculation, use measures "Transitions to issues count" and "Transitions from issues count" in combination with the dimension "Transition Field" and specify the field "Agile Team".

2.1. Expression to show how many issues transitioned to a team during a selected period or sprint might look like this:

([Measures].[Transitions to issues count],
[Transition Field].[Agile Team])

2.2 And a similar measure to show how many issues moved from each team during the selected period or sprint might look like this:

([Measures].[Transitions from issues count],
[Transition Field].[Agile Team])

More details on calculated measures and tuple expressions: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures

3. You can also use the measure "Issues history" with the dimension "Agile Team" to see how many issues were assigned to each team each day.

More details on the mentioned historical measures are in the documentation: https://docs.eazybi.com/eazybi/data-import/data-from-jira/import-issue-change-history.

Best,

Zane / support@eazyBI.com