Enhancing your dashboard charts in Jira through Dashboard Hub

Enhancing your dashboard charts in Jira through Dashboard Hub

Jira chart by created quarter

Jira dashboards are designed to display the gadgets that keep track of a project’s metrics and data. Usually displayed as charts, these dashboards are useful because they give you the power to view everything that’s going on in a project at a glance. While Jira offers out of the box gadgets that will generate charts for you, these charts are currently incredibly limiting.

For example, the default Pie Chart gadget that Jira offers only allows you to select the project, the statistic type that you want to display, and an auto-refresh option. For simple cases, this might be enough. However, it’s common to want to set the colors for each statistic type, select custom fields, or perform extra calculations by accessing aggregations to calculate sums, min or max values, average, etc.

Configuring the default Pie Chart gadget
Jira Pie Chart display
Sample result of a Pie Chart gadget by Jira

Fortunately, there are multiple apps available in the Atlassian Marketplace that can solve these limitation issues for you. One of those apps is Dashboard Hub for Jira, built to overcome any shortcomings related to a standard Jira dashboard by offering the ability to create custom charts for your reporting needs. Not only does Dashboard Hub solve the lack of customization in Jira chart gadgets, it also allows you to connect your dashboard to other Atlassian apps such as Bitbucket, Confluence, or even external Jira instances (view the list of integrations here), plus you can share your dashboard externally through a secure external link. You can also opt to get started quickly by loading a pre-defined dashboard template with more than 60 gadgets.

Adding custom charts with Dashboard Hub

Add custom charts into your dashboard by selecting the JQL Search gadget under the Jira section. The gadget will then appear in your dashboard. Next, configure the gadget by clicking Config.

JQL Search
Start by filling in the display name and selecting the data source. By default, the data source selected will be the Jira instance you are currently on. Choose the Add data source option if you would like to add a new data source.
JQL Search config
Configuring the JQL Search gadget’s data source

Next, select the scope of information that you want to display by selecting either Filter or Custom JQL. For simple use cases, the Filter option should be enough because it allows you to select an item from your existing filters. Custom JQL should be the option to use if you would like to perform more complex filtering since it uses the Jira Query Language to help you narrow down your selections. For example, if you would like to display only the issues where the status is In Progress and sorted by date, the JQL Query representation would be:

Once you have finalized your filter, click the Load button.

JQL Search filter
Filtering the JQL Search gadget’s issues

Now, select the type of view that you want to use. The view types include table, line chart, pie chart, bar chart, tile chart, grouped bar chart, stacked bar chart, and multi-line chart. Depending on the view you use, there will be additional fields that you need to configure. For example, if you are using a Pie Chart view, you will have to configure the Chart By value, which is the field that you want to chart against.

Additionally, you will also need to select the Aggregation type and value. Aggregation options include count, mean, min, max, and sum. A chart display will automatically generate depending on the fields you selected.

Bar chart Dashboard Hub for Jira
Configuring a JQL Search gadget with a Bar Chart view

Once you are done, click Save and the chart will be automatically generated into your dashboard.

Advanced charts with date and time fields

A really powerful mechanism to make the most of your data is the ability to use data and time fields. Imagine you need to display the total time your teammates estimated for a given project. Well, no problem, select the view type that best displays the information, like the Tile Chart (View Type), select the Original estimate (Field) and Sum (Aggregation) it:

Assignee by original estimate
Tile chart: Total sum of the original estimations per assignee
When you Chart By a date field, you probably want to group the results by a different granularity. If you want to see the number of issues by creation date, and your team is medium-size or big, it makes no sense to display that information by day. Instead you can group fields created by quarter, giving a real useful representation for your report.
Jira chart by created quarter
Pie chart: Number of issues created per quarter

Summary

When creating dashboards, it’s useful to utilize Jira’s default chart gadgets to illustrate simple datasets. However, these gadgets do not offer key features or functionality you may need such as performing aggregations on data, executing complex filtering of issues, and customizing chart colors. Dashboard Hub’s custom charts feature was created to solve these issues, so you can gain a customized visualization of your data and metrics at a glance.

Not currently a Dashboard Hub user? Click here to try Dashbord Hub for Jira (and for Confluence) and benefit immediately from this powerful app.

Leave A Comment

Your email address will not be published. Required fields are marked *