Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

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.
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.

1 answer

0 votes
Zane eazyBI Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 23, 2023

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:


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:


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:


Zane /

Suggest an answer

Log in or Sign up to answer