Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,362,540
Community Members
 
Community Events
168
Community Groups

Jira Issue Keys in EazyBI Table Matrix

Hello all. I am trying to make an EazyBI report very similar to the one found in the below community question, but I'm showing issue Components in the report rows and Labels in the columns:

https://community.atlassian.com/t5/Jira-questions/Issue-rating-for-Jira-matrix-view/qaq-p/862810

However, instead of showing the Issues Created count in the table, I want to show the Jira Issue Key(s).

I have created a new calculated measure for the issue keys as

[Issue].CurrentHierarchyMember.Key

but, when I use that calculated measure, the entire table fills with zeros (0). If I add the Issue dimension to my report rows, so my Jira issues are shown in the rows, then the entire table is filled with the Issue Keys rather than only the cells that cross-reference the appropriate component and label for the issue's data.

 

Am I using the wrong calculated measure syntax to accomplish what I want or is EazyBI not able to display exactly what I'm looking for?

1 answer

1 accepted

0 votes
Answer accepted

Hi @Adam Schordine ,
Yes, this is expected behavior that issue property ([Issue].CurrentHierarchyMember.Key) is shown in the report only when the Issue itself is visible. If you want to see the issues behind the number, I highly recommend using the option "Drill through issues":
eazybi_drill_through_issues.jpeg
 There is an option to create a calculated member using Generate() function, but the end result can be a report with poor performance as you need to iterate through all issues. And the end result can be hard to overview as there can be an unknown amount of issue keys per cell. 

 

best,
Gerda // support@eazyBI.com

Thank you very much for the explanation, Gerda. I appreciate you taking the time to reply.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events