Showing the Fix Version of the Parent Epic

Questions & Answers
1

Hello Community,
Is there some way to show the fix version of the parent Epic on the issue level?
We would like to show a list of issues ([Issue] Dimension) and for each one show the Fix Version of the parent Epic (assuming the epic is allocated to only one Fix Version).
Any help will be appreciated.

2

Hi,

In this case, you could first ensure that you have imported custom field “Epic Link” via eazyBI import settings.
That should create additional properties where the Epic key would be stored for each issue.

Next, you could create a new calculated member in “Measures” dimension using this code (and property Epic Link):

NonEmptyString(Generate(
  Filter(
  [Fix Version].[Version].Members,
  [Fix Version].CurrentHierarchyMember.Name <> '(no version)'
  AND
  ([Measures].[Issues created],
  [Issue Type].[Epic],
   [Issue].[Issue].GetmemberByKey(
     [Issue].CurrentHierarchyMember.get('Epic Link')
     )
   ) > 0
   ),
  [Fix Version].CurrentHierarchymember.Name , ","
))

Note that this approach would work only for regular hierarchy in “Issue” dimension.

report example
report example.jpg2294×1442 646 KB

Kind regards,
Martins / eazyBI team

3

Thank you Martins. very good. I checked it and it works fine.
Thank you very much

4

Hi!
In the screen capture I see, within issue properties, the field “Issue fix versions”. I cannot seem to find this field in my measures dimension. I understand this should have been created automatically?
What would be the formula for this field?
Thanks!
— Jacques.

5

I think I figured it out myself. This would be the formula to show the issue’s fix version:
Nonemptystring(
Generate(
Filter(
[Fix Version].[Version].Members,
[Measures].[Issues created] > 0 AND
[Fix Version].[Version].CurrentMember.Name <> ‘(none)’),
[Fix Version].[Version].CurrentMember.Name, ', ’
))

hope this helps.

6

Indeed Jacques, you got it right. this is a user defined field. you wrote the correct formula.

1 Like
7

Hi, I am having the same issue. I have seen that the formula you propose is not working on my side. It gives me an syntax error.

I am using instead this one:
Nonemptystring(
Generate(
Filter(
[Fix Version].[Version].Members,
[Measures].[Issues created] > 0 AND
[Fix Version].[Version].CurrentMember.Name <>“none”),
[Fix Version].[Version].CurrentMember.Name, ', ’
)
)

After using it, I can see a column with “issues fix version” but all items have “no version” on it. I am missing other versions we have in the project. What could be happening?

8

Are you sure you’re using this together with the [Issue] Dimension?
Put the Issue in the Row, and the Measures in the columns.
See attached

image
image.png890×432 12.1 KB

9

Yes, I am doing so and I can only see two options now from all the versions we have in JIRA (‘no version’ option and V 0.0.1). Somehow, eazyBI is not noticing the rest of all versions we have.

10

The showed issues are not all issues we have - eazyBI stops showing issues higher than issue number #1127 on this case. So all JIRA issues generated after that are not appearing in the table. Why is that? Maybe some synch issue?

11

Sorry, I don’t know what’s wrong with your report. May be you ask for EazyBI support to help.

1 Like