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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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,457,480
Community Members
 
Community Events
176
Community Groups

Unable to create Issue Link Field Dimension for eazyBI Report

Gaurav Community Leader Apr 26, 2022

Hello All,

We need to create a report where the filter would be on the Quarter field of the Epic and need to add the efforts for issues under the epic. The custom field 'Quarter' is available only at the Epic level. 

The report needs to be filtered based on the custom field 'Quarter'. If we filter based on Quarter, it filters out all the underlying issues (stories, tasks, sub-tasks) as they do not have the custom field. 

Based on the documentation, this can be achieved using the Issues Epic Hierarchy. We added the code in Advanced Settings for 'Issue Link Field Dimension' and performed a full import but it did not create the Link Field Dimensions. The code added to Advanced Settings was the same as provided in the documentation: https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/issue-hierarchies#Issuehierarchies-IssueEpichierarchy
Kindly suggest the optimal solution to filter data based only on the quarter field of Epic ensuring that the underlying issues (stories, tasks, sub-tasks)  are not filtered.

1 answer

Hi Gaurav,

If your "Quarter" field is a single value field in Jira attributed only to Epics, and you would like to filter Epic child members by this Epic value, you can introduce an Inherited field dimension in Advanced settings with the help of custom Javascript code:

[jira.customfield_NNNNN_e]
name = "Epic custom field name"
data_type = "string"
dimension = true
update_from_issue_key = "epic_key"
javascript_code = '''
if(issue.fields.customfield_NNNNN ) {
issue.fields.customfield_NNNNN_e = issue.fields.customfield_NNNNN;
}
'''


Replace the NNNNNs with the IDs of your custom field. The "update_from_issue_key" parameter will specify from which hierarchy level you would like to pass down the values.

When this is saved, go to your Jira import options, select this new field for import, and you should see the "Epic custom field name" dimension available in your report creation section.

Best regards,

Nauris / eazyBI support

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events