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,295,079
Community Members
 
Community Events
165
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
Community showcase
Published in Confluence Cloud

Presenter Mode for Confluence is here 🖥 👩‍💻

👋  Hello Community!  My name is Stephanie Zhang, and I’m a product manager on the Confluence cloud team. Today, I’m excited to announce the rollout of  Presenter Mode : a ...

80,146 views 126 303
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you