nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pull data from various issuetypes in Jira

Aswini Rajasekaran

Hi, I have the below requirement. Can this be done in Jira?

Portfolio have the hierarchy defined as: Initiative, Feature, Epic, Story.

I want to build a report with the list of Stories that belong to an Epic (filtered by a custom field value) and the related fields of the corresponding Feature & Initiative.

I tried in EazyBI, but it times out every time I try to pull the data. It will be good if theres a solution in Jira itself rather than plugins

Thanks very much for any help.

Accepted answers

Roberts Čāčus - eazyBI

Hi @Aswini Rajasekaran

Reports in eazyBI can timeout because of the amount of data that needs to be considered. In your case, it could be the list of all issues expanded causing that.

Nevertheless,if you are open to exploring the option of creating the desired report with eazyBI I recommend importing inherited field dimensions with the help of JavaScript calculated custom fields - https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Inheritedfielddimension.

Define new JavaScript calculated custom fields or new calculated fields in eazyBI and pass the custom field value from Epics (use the value "epic_key" in the parameter `update_from_issue_key`) and from Advanced Roadmaps hierarchy issues (use the value "jpoh_parent_X" in the parameter `update_from_issue_key`, X being the number of level above sub-task in the Advanced Roadmaps hierarchy).

After importing these inherited fields as dimensions, you can use them in the report pages. In rows, you can select the Issue dimension in the "Advanced Roadmaps" hierarchy and use the "Story" level. The report could look similar to the one below:

Screenshot 2023-10-11 at 12.28.52.png

The report is filtered by the inherited dimension "Epic Epic Direction" that is based on the the custom field "Epic Direction" available only in Epics. With this filter and a numeric measure in the report, you can also view the issues in the Epic with the particular value in the field.

Let me know if you have any questions.
Best,

Roberts // support@eazybi.com

All comments

Roberts Čāčus - eazyBI

Hi @Aswini Rajasekaran

Reports in eazyBI can timeout because of the amount of data that needs to be considered. In your case, it could be the list of all issues expanded causing that.

Screenshot 2023-10-11 at 12.28.52.png

Let me know if you have any questions.
Best,

Roberts // support@eazybi.com

Aswini Rajasekaran

Hi Roberts, thanks for that. I am able to pull the data from hierarchies using the javascript mentioned above. But as I said that the report times out even with 1 project, it doesn't look to be a viable solution.

EazyBI is a powerful tool, but timeout is a big issue when we are working with bigger dataset.

So, I am looking for other options.

Aswini

Roberts Čāčus - eazyBI

Hi @Aswini Rajasekaran

Fair enough. If you change your mind, you can share the definition of the report here or at our support email, and I can see whether there is room for optimization in the report itself - https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions.

All the best,
Roberts // support@eazybi.com

Aswini Rajasekaran

Hi Robert, attached the report definition.

{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Project story",
"folder_name": "Aswini's",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Issue Story Points]","[Measures].[Issue resolution date]"],"members":[]}]},"rows":{"dimensions":[{"name":"Advanced Roadmaps Initiatives/Theme","selected_set":["[Advanced Roadmaps Initiatives/Theme].[Advanced Roadmaps Initiatives/Theme].Members"],"members":[],"bookmarked_members":[]},{"name":"Advanced Roadmaps Features/Agile Initiative","selected_set":["[Advanced Roadmaps Features/Agile Initiative].[Advanced Roadmaps Features/Agile Initiative].Members"],"members":[],"bookmarked_members":[]},{"name":"Advanced Roadmaps Epic","selected_set":["[Advanced Roadmaps Epic].[Advanced Roadmaps Epic].Members"],"members":[],"bookmarked_members":[]},{"name":"Issue","selected_set":["[Issue.Advanced Roadmaps].[Story].Members"],"members":[],"bookmarked_members":[]},{"name":"Epic QBR","selected_set":["[Epic QBR].[Epic QBR].Members"],"members":[],"bookmarked_members":[]}],"filter_by":{"conditions":[{"expression":"[Epic QBR].CurrentHierarchyMember.GetCaption","operator":"matches","value":"QBR3","value_type":"string"}]},"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"AIB Fulfilment","full_name":"[Project].[AIB Fulfilment]","drillable":true,"key":"AIBF","parent_full_name":"[Project].[All Projects]"}],"bookmarked_members":[],"current_page_members":["[Project].[AIB Fulfilment]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Epic QBR":true,"Advanced Roadmaps Epic":true,"Advanced Roadmaps Features/Agile Initiative":true,"Advanced Roadmaps Initiatives/Theme":true,"Issue":true}}},"calculated_members":[]}
} ],
"calculated_members": [{"dimension":"Measures","name":"Issue resolution date","format_string":"mmm dd yyyy","formula":"[Issue].CurrentHierarchyMember.get('Resolved at')"},{"name":"Issue Story Points","dimension":"Measures","formula":"[Issue].CurrentHierarchyMember.get('Story Points')","format_string":"#,##0.00"}]
}

Error:

Failed to execute query. Error message:
Illegal Capacity: -1104072124

EazyBI JVM options: Xms:4GB Xmx:8GB

Thanks

Aswini

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server