Created Bugs vs Resolved Tasks by Affects Version and Fix Version

Questions & Answers
, ,
1

Hello everyone, I need to create a report that will show how many tasks were closed and how many bugs were created in each version. The problem is that the created bugs need to be filtered by Affects Version, and the closed tasks need to be filtered by Fix Version. I need to create a table like this:

Release Version Created Bugs (by Affects Version) Resolved Tasks (by FixVersion)
release/0.1.0 10 40
release/0.2.0 2 20
release/0.3.0 30 30

Has anyone solved problem like this before?

1 Like
2

Hi @egor.muradkhanyan,

This is an interesting reporting challenge that requires creating calculated measures that use different version contexts. Here’s how you can solve this:

Step 1: Set up the report structure

  • Use Fix Version dimension in Rows
  • This will serve as your “Release Version” column

Step 2: Create calculated measure for “Created Bugs by Affects Version”

Create a new calculated measure with this formula:

(
[Measures].[Issues created],
[Issue Type].[Bug],
[Affects Version].[Version].GetMemberByKey([Fix Version].CurrentHierarchyMember.Key)
)

This measure will:

  • Count created issues of type Bug
  • Use the Affects Version context instead of Fix Version
  • Function GetMemberByKey switches the Fix version name with the Affects version name. It finds the Affects version name based on the Fix version name visible in report Rows.

Step 3: Create calculated measure for “Resolved Tasks by Fix Version”

Create another calculated measure:

(
  [Measures].[Issues resolved],
  [Issue Type].[Task]
)

This measure will:

  • Count resolved issues of type Task
  • Use the Fix Version context from the rows (default behavior)

Step 4: Set up the report

  • Add Fix Version in Rows
  • Select both calculated measures
  • Optionally, add other dimensions to Pages for filtering (Time, Projects, etc.)

Best,
Marita from support@eazybi.com

2 Likes