Problem

My Custom Charts in Jira are having issues.

Solution

Below are the best practices for Jira Custom Charts

General Dashboard Best Practices

  • No more than 10 custom charts on a Dashboard
  • No more than 20 gadgets on a Dashboard 
  • If a Dashboard has a performance impact, limit the users who can view the Dashboard. 

JQL Best Practices

  • Permission-checking can have a large impact on performance when searching - narrow it down to your project instead of "general". 
  • Use the JQL Function sparingly.   
  • Avoid using "filter IN" to combine smaller views into larger team views. 
  • Avoid nested JQLs
  • Avoid Sorting (Order by): this can cause performance concerns, especially on custom fields and app fields.   
  • Only use necessary fields in your filter; scripted fields or third-party fields can affect performance. 

Example of a filter causing performance issues

(filter = "Example" AND ("Target end" > "2024/09/25" OR "Target end" is EMPTY)) OR (filter = "Example" AND ("Target end" > "2024/09/25" OR "Target end" is EMPTY)) OR (filter = "Example" AND issuefunction in issuesinEpics('"Target end" > "2024/09/25" OR "Target end" is EMPTY')) ORDER BY priority DESC, cf[11705] ASC

Additional Information

Factors contributing to JQL performance in Jira Server and Data Center

Alternatives

  • Try to use Power BI: download the data and then filter the data according to the reports that need to be produced - also, setup the data refresh on a schedule, no more than once per day.
  • A custom chart can be downloaded in the form of a pdf or image: this can be uploaded on a Confluence page and/or SharePoint.