...
- Exclude Done issues from all filter result gadgets, active sprint and backlog gadgets unless specifically required.
- Use the following JQL to exclude done items:
...
| Info |
|---|
|
All chart and list gadgets must rather to be based on a saved filter. Do not use ad-hoc JQL directly in gadgets instead of creating a filter first. Same as above "Exclude issues in Done statuses from your filters to avoid long loading gadgets and performance impact in Jira |
Use gadgets from Custom Charts where specifically needed, if you want to show filter results, use the default Filter results gadget for this.
Custom Chart per quarter example:
Image Added
| Expand |
|---|
|
Chart code to import the example | Code Block |
|---|
{"id":"GIQQIg7AogTEA","title":"Q","titleType":"MICQggSgKkA","searchType":"FIRQMkA","aggregations":"NobwRALgngDgpmAXGAwgeQKoDkAqYA0YAhgOYkBOcJREcAQlEmAJIDKrGAoqwWAMYB7ADYDyTAMQAjAGYAmAGwAGRWAC+AXSA","query":"A4Jw9gVgpgxgLgAgLwIJ4EsDOCCCA5AEQUzgEM4BXTAYXKgHMwRUEBCFAEzADsog","customColumns":"NoXSA","displayOptions":"N4IgzgFg9g7gQlATgEwKaJALgGYEMA2YqANONDACq4BG+qACugMaoB2ALmFu4gK4llYVWqgCSYMPy6Ye-UpFgAtdFABqBfgBkaqQljyEBCylHYEAwlF4d9BIvPIVTFqPl4BbVtz5HyAcUQrAAc4AE9vOUEYTVQAczZkCN8hRAS-KAIAQQA3dFx4mPjWRJkfB1gADUyADwBLMG1qXSTymABNGvrG5tLI4ydXdlqggHlWOFxEAAkoXIxegVxedigAJVRsVMhbQ1ICfFgRoKGoVjAAWTZeFpB92ABRaqCkdhvjToa4hMtrV4XWj6FBKMRAsGw4OwCJgQSbsCihIKoLAgADKFEy5gA0vcACIAfTgmVWIFIiNBbHYOPqQXwuHCmBAqkymgAqvcSbc6mAUeQQWC-gZ7FFlIE+RTunoIbsQGT+VSwDS6RRanRkUzWfc8fR7qtzPcAHIUDmyinyxWhei1JEM9VsrU6vWG43MU3U2mhD5q5lsjlMAhMXi09gMF0cfKoEbYZEUEbozQcuhFZD0KBgWonLwMhDsFbuBNfYraUJWP4gGaIWoAL1OZnwHKG7DomXwtVirHcFORjooOo5aDATArx1qpxTaYzyOzuY5xhZREQoncZLAp1wE-+ICYLaYAGsKBBArxYhAbomEqtYJpau501gAIwABlIQzo5hhiHYomD7jAIIvMCwABWUgPS5N9YSmVBWwgdgrxvP4ACYADYnyiHFUAHId11kZJoh0SUcNafUPCaRBLDcTw3nIcRJFQeFER2IVWBI9AAmCWpWFiZFRDjURMn1PE-FWEYWXoUR9T8DlmPcUj6FSJh6hHTM71JUMzHiOTUAUtNTnvPZYliVJYjXJTlQ7FlWFvBkphE1YUQ5fJDLiEzTjM1AZl4RBVhcrAAA5SADdxAxM3InFrRioQ8YKhlC5x8DCLspiJCgCTaPtJh3c4oDQCLWgGfAhlGVh9VwDsZjmXKoksGSONQZAACkAEc6ylIVQPqCyrJAH4bFIZA11QAAxJB3DXZEcUyNo8UG0Q7JSlEbNWI1WnLKsawIK9WAwyrjFUdAhj9fBNu21rcL2j9akO8r0GOqjL1q8CP0sVgtqYIZOOO6RCJAZB6hoOgpgRdAW1YHdpEFKErA4TrGv4GipBuGBUFQHcUTMD8cTpPSQF4IgAHUkB3A5YjndA3MUU5UEx4Mbl+sAeFqahljo69UBRREOEyQdUzAbzOJOiG+r+kRzFwaFrUFkBqkQOlBo4gg0bXXGMM0lg0FYFgIoAXyAA","series1":"N4IgxgFghgTgLgIQJ4EkAmIBc4YFMpy4YA0IAzrgOYC2uAdnGQMID2dAZgJaUCuMBnNllAA3APoAmAAwSAbAFoAihOEhOdNLgAeWKaQo16jLAG1QnDNnHS5SlaRFQANj1xYQNhcpCk6UWu7KAASeIAC+ALqkYCxOLDDuAMQIAGJyUlI+ICKcZJwARk5umHAwrmEOkjIArEoAzKrqmjqYAIz6VLQMZKbmltlVErWKDQ7Oru42w6MgfgHYIyE14VHgsfFJKSkAnNutKVk5eYXFpeWVU0oALI0a2lgSHYbdvWr91jXXh+PFHp+KN18-l+AKWQxW0XWCWwiS2TCuGUOuQKRSwZ1wFQGniUrVuzSwdSeXWMmDMb3cH1silxYxcv2x1KycxBrTBsghazi0JAiWqEiudQAgoKkcdUSUyhjMWgCLgAMqdIzMNhcXj8OCCOiqSgwFg8AAO6kogQAqoKAEoAFQAoua5Vl+HRKL8ACIATQAcoKALIoJhic2Cj0AcWtWXYuuo7nkdW2AHcsnAWO4rgnMdQCJA5cCUpxcE40D1MOxnBRSDq9fqmFAyGAoJpc-nC1gS04yyAeBRWFyi+jSPFNDAje5YpoyHAxHRcHHcOOsmQICw4wAtXC61g8F4S1yQrkAGRYYAA1i3SxigA","series2":"N4IgxgFghgTgLgIQJ4EkAmIBcICWBnPAVwFM4kAHYkAGhD2IHMBbYgOzjwGEB7VgMxwNCMKHBy8soAG4B9AMrkcAayqZQOVmmIAPLACZa9Zmw5YA2uozZZC5VVpSoAGxJYQtlTRCsoLNx-tcMF4AVRgnNwg4OHI8TAB6eKJycm54ADokX1ZSdOCmJOIwYWJ4qRxiAHcoRzhYAH48HAAvYgBebTwmZycAMhrRWHQ2gEYABgBmPT1+2tgAFQp2-CJSJZAAXwBdWmCnNLcAYgAxY4AOBDGxr3KmgCMnVTgYEg2HGXmoPCVJXE0dLATQyMFjsPDmSxuWSfb43ZyubAwn60Hx+RFfZFBULhSLRWIJJKEFJpOCZbK5fKFYowUrlKoDOowRotdqdbpOPoMoZoUaTEZnWaDGCLShtFYkMiUTY7cDcfYwI4TKBoCbEM43fA4B5PF7EN4gWQAUUUYF+Gi0ukwY2BxjBENwVgNMmNOFNDnhqhALrd3l8nu9Xld2Ii2CiMTiiWSqQyWSYOVJlJw3QYxDw8SDrDT4rWlDTxBN6TwUgY0t2coO2EOZwA7LWACIATg190eWGer3e81TcDN-0tDZtoNMmAsDqhH27cJcnq7eB7KL9bln86xrDCIZAYfxkaJ0dJsfjeW4BTQ3EqrH2yviNLw3GEYFT8Xy6W05CgmhwpPILgYGjwL5EJB02TR84G7dJyFYEttjLeUjlOTgABYrmbLVW0wPhnHofVZAQQgSzUP4LSwRDBxMcER0hawZDwkt3WnNxaK8VFPSY2gM3XXFwwJKMSTJOMKWPKkSjKCpqjmJkmlaDouh6QVGWGcYJkmeSFiWMUCAldYYNlODKzrQ0JgAVjGBBUO1NtdRwmQAB0QGXAACQ1tCKQgxF4Oze2IzAzjIu1KLHai7Mc5zXPc1hPPohEQGC7snJc4pwsi300XsuLQsS8RWEDYI1xxUM8QjQliRjckEyE09z0vNBr1TO8YAfNNn1fd80E-CCfz-ACoCApMoBTNMwLnABaHQwqyiCoNLXSKxAQ4DOM0zzPQzCnGw95YrnByAAUnHfTzCPNAFMGrPzh1HHBHVkTa4B2vaIpAKdopuu79sehdUsc3b3xy4MuO3Yq934w9KUqi9uCvG96sap9jxfN8Py-TrM263qQMG7thu-d9JugmU9lmw4rgANmJxDEOW1RVvWp05EIO5hrqWFDr7LBibOiiLqu+R6cZjEns9OmGaZzEWP8XmRd+vKNy3IreNKgTyoKehqVpMSuUklkZPZTkJMUvlidU4V1OzSUqB0gmFUrBAJjrRDTkpyyOydOtiD4IoexZ7yjI5+1LvHV33bAFdHAY7BA495jF3Dt3I-Y3LOIK7idxK-cyqPZXXJpUT6Qk5lpLZOSNf15SJiNkVlk0nNzfx8srbmkyjOOasmwcTULMwds9Q2kBOGgKDiAcgAlYgAEcSDnA71FZzARgMOgQXIv3ubsvv3xTYex4nuBktD57e-7jeR-H7tkrF7A14HzeT7nKXE83QqeN3PiD0EzPVZz8ShXz1lZI5I2S56DGOXE2VczbTUtkcGs9ZW4GnbitLC3cnR2UND4bUDk5BwDSEgKeRFjojBGL7AK-sgpejQY8DBWCYA4PegaD0bgUHkMHpg7BZ9o5kKgOglh1C775QfsnQGL906UhViJOkX9GQ-21kXPWPIlLjBAaKU22la56Tmu7O4DYzgjEdhhRB1luFIC8vgohXNxyGIFv4KhRiPqC2sbwmWj8U5A1fkrYC-VHwZizGApYaY5zYMLMWCBddFTExttWQ0uiu7WW2jSYaPBEZZWMZacYpiqJOlicQeJvA2rhUsdgTJ2TEkSFsW4QpCTclJPjn9JOAN5Zp0VhneIYNqq1VvPeR8zUEa5I6vhLq2hALuIGvEcgcTcqVN4LjYJaiiZjDOE3Y4ujqZ6n1N0OAkA5B+mOBUJwaAKLLNoAwGAd5yCcC+GAZUxBtnEF2fsxBtBCD0B4PKO5a1iC0DSFoGAGgCLgEeVgpgXg8AQDPAALWIMcnghB-IHJmjAAAMtwMAPw9FvI2EAA","jiraFields":"NobwRAlgJmBcYGMBOBTAhgFxTANGAdmgLYpxgDCqm2YeCANmgK4DOKAcsafMullABFqtRI1YoAkjB5V+IlggAWKImjjgMATwAO3MFGoYIJeZpZYiZXtRgBfWznDQyEFiyYotukYRPwJbh4ABAAqOqR0YmycfmBeEaLMbFIugZ7h8koqarAaGfCu7uneeCxmFqlF8WD2ALpAA","version":"1"} |
|
Creating Filters for Dashboards
- Go to Issues > Search for Issues
- Build your JQL query
- Click Save As and give the filter a clear, descriptive name (e.g. SPARKLE - Open Bugs Q2 2026)
- Set filter sharing to your team or project so others can use the dashboard
Filter Naming Convention
Gadget Guidelines
- Two Dimensional Filter Statistics - use for breakdown by assignee, priority or status. Always base on a saved filter.
- Filter Results - limit to 20 rows maximum to avoid performance issues.
- Pie Chart - use for status or priority distribution only. Avoid using on filters returning more than 500 issues.
- Created vs Resolved - useful for trend analysis. Set period to weekly for sprint dashboards, monthly for programme dashboards.
...
Each quarterly dashboard should contain the following gadgets:
Gadget | Purpose | Filter example |
|---|
Filter Results | Open issues this quarter | project = X AND fixVersion = "Q2 2026" AND statusCategory != Done |
Pie Chart | Status distribution | project = X AND fixVersion = "Q2 2026" |
Two Dimensional Filter Statistics | Issues by assignee | project = X AND fixVersion = "Q2 2026" AND statusCategory != Done |
Created vs Resolved | Throughput trend | project = X AND fixVersion = "Q2 2026" |
Filtering per Quarter
Use Fix Version or a label to scope quarterly dashboards. Recommended approach:
...
Dashboard Ownership & Housekeeping
Rule | Detail |
|---|
Every dashboard must have an owner | Set in dashboard permissions |
Review dashboards quarterly | Archive or delete dashboards no longer in use |
Do not share dashboards as public | Share with specific groups or projects only |
Broken gadgets must be fixed within 1 sprint | A gadget showing an error affects all viewers |
...
Need Help?
If you need help setting up a dashboard or filter, raise a request via the IT Service Desk.
...
Last updated: May 2026 - Maintained by iSPARKLE-SPARKLE team
