Can not export Gantt Chart to excel due to the numbers of issues.

[NGS Takuya Niikura]

Hi community,

I am facing an issue which the Gantt Chart can not export to excel due to the massive numbers of issues on Jira. The same case of matter was happend previously. That time, I broke the project down to each epics and was able to proceed succesfully. In our project, we put parent as Epic and below for Stories.

However, one of the Epic got too much issues recently and I am confusing.

My question would be how can I provide each story to be on Gantt Chart? 

I tried to put JQL to separate two Gantt Chart by Stories to reduce the numbers of issues. But there are no JQL to select story.

It would be great if someone could help me from this situation.

[Doreen Undiri]

Hi @NGS Takuya Niikura

Below are some of JQL filters to manage the number of issues displayed on the Gantt chart,

For example,

• to focus only on Story issues, use issuetype = Story, which will limit the view to stories only.
• If you want to see all issues linked to a specific Epic, use "Epic Link" = EPIC-123, replacing EPIC-123 with the actual epic key.
• Filtering by a specific Assignee, use assignee = "username", substituting "username" with the assignee’s Jira username.
• Filter by Status with status = "In Progress" to focus on issues currently being worked on.
• Or narrow down issues by Due Date range, you can use duedate >= "2023-11-01" AND duedate <= "2023-12-31" to display issues with due dates within a particular timeframe. 

I hope they will help...

---

Dd