Created Vs Resolve chart with JQL

Questions & Answers
1

Hi,

I want to generate created Vs Resolve chart with the following query
category = “ART” AND (component = component1 or (component is Empty AND assignee in (user1, user2, user3))) AND issuetype = Bug

Thanks,
Prasad

2

Any Update on this ?

3

Hi Prasad,

In this case, you could first create a new calculated member in “Assignee” dimension with the following code:

Aggregate({
	[Assignee].[User1],
	[Assignee].[User2],
	[Assignee].[User3]
})

Then, you could create a new calculated member in “Measures” dimension:

 NonZero(
  Count(
    Filter(
      Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
      (
        [Project].[Component].[Component1],
        [Measures].[Issues created]
      )>0
      OR
      (
        [Project].[Component].[(none)],
        [Assignee].[Calculated member],
        [Measures].[Issues created]
      )>0
    )
  )
)

Finally, you could use “Issue” dimension in rows, “Project.category” dimension and “Issue type” dimension in page filters and select your new calculated measure from “Measures” dimension.

report%20example
report example.jpg2638×1338 500 KB

Best regards,
Martins / eazyBI team

4

I have tried with your answer, I see issue count for only one project as below

image
image.png814×835 28.9 KB

how we can add component by name instead ? same component will be there across multiple projects.

how to show, created count vs resolve out of this.

Thanks for your support!

5

Still looking help on this…

6

Hi,

What is the code you tried for your calculated measure so far?

Kindly,

7

I did the following steps,

  1. created calculated member in assignee dimension

  2. create new measure as follows

     NonZero(
   Count(
     Filter(
       Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
       (
         [Project].[Component].[Firmware],
         [Measures].[Issues created]
       )>0
       OR
       (
         [Project].[Component].[(none)],        
         [Assignee].[Team],
         [Measures].[Issues created]
       )>0
     )
   )
 )

then it showing as follows

image
image.png1192×602 47 KB

8

Hi,

Please also share the code you used to create a calculated member “Team” in ‘Assignee’ dimension.

Br,

9

Hi,

Please try using “no component” instead of “none” in that code.

 NonZero(
   Count(
     Filter(
       Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
       (
         [Project].[Component].[Firmware],
         [Measures].[Issues created]
       )>0
       OR
       (
         [Project].[Component].[(no component)],        
         [Assignee].[Team],
         [Measures].[Issues created]
       )>0
     )
   )
 )

Br,

10

Aggregate({
[Assignee].[user1],
[Assignee].[user2],

})

user1 and user2 is user login id, is it correct or i have to use user full name?

11

tried with above code also but i don’t see any difference

12

Try using calculated member with user Full names.

Aggregate({
[Assignee].[Full Name1],
[Assignee].[Full Name2]
})

And there shouldn’t be a coma after the last member (in the code).

Br,

13

yes, i tried that too but no luck.

JQL query fyi: (category in (“category1”, “category2”) OR project in (SAIN)) AND type in (Bug) AND (component = Firmware OR (component is EMPTY AND assignee in (user1, user2, user3)))

14

Please provide the exported report definition to support@eazybi.com
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions

Kindly,

15

I have sent the email as you requested

16

Hi,

I can confirm we received the email and will try to answer it very soon.

Martins / eazyBI support