Jira
-
Click Add gadget while editing a dashboard and type Custom Charts in the search
-
Select the first gadget from the list, Custom Charts
-
Go to the newly added gadget, and edit the Source field to choose which issues are included in the chart
-
Navigate to the Chart By dropdown and choose a Jira field, Custom JQL, Saved Filter, or Date to break that data down further
-
In the bottom right hand corner of the gadget or macro, click Save
To customize your charts even further, check out these pages.
Confluence
-
While editing a page, click +˅ in the editor and type Custom Charts in the search
-
Select the first macro from the list, Custom Charts
-
Edit the newly added macro, then edit the Source field to choose which issues are included in the chart
-
Navigate to the Chart By dropdown and choose a Jira field, Custom JQL, Saved Filter, or Date to break that data down further
-
In the bottom right-hand corner of the gadget or macro, click Insert
To customize your charts even further, check out these pages.
Chart Essentials
1: Source
Required
Choose the Jira data to display on your chart.
The options are:
-
Jira projects - pulls in issues from the selected Jira project(s)
-
Saved filters - can select a saved Jira filter and the data pulled in will meet the JQL criteria of that filter (used in the chart above)
-
Custom JQL - write a custom JQL statement and the chart will display issues that meet that criteria
-
Simple Search - allows users to dynamically filter their charts once a Simple Search gadget/macro is created. As a note, if you Simple Search to a Dashboard or Page first, all Custom Charts and Issue List gadgets/macros added after will automatically connect to it.
-
Structure - allows users to pull in issues from a specific Structure
2: Chart type
Choose how the data is visually represented on the Dashboard or page. You can change the chart type at any time.
The options are:
-
Pie Chart (Default)
-
Bar Chart
-
2D Grouped Bar Chart
-
2D Stacked Bar Chart (used in the chart above)
-
Line Chart
-
2D Line Chart
-
Funnel Chart
-
Table Chart
-
2D Table Chart
-
Tile Chart
3: Chart by
Required
Choose how to segment the data on your chart. For example, if you choose a Pie Chart, the Chart By selection indicates the slices of the Pie Chart.
The options are:
-
Custom JQL - segment the chart by writing a JQL statement directly in the gadget/macro
-
Saved filter - segment the chart by selecting an existing Jira filter
-
Dates - segment the chart by dates
-
Fields - Choose any custom field, system field, or field that comes from another app
4: Group by dropdown
Required for 2D charts
Choose how to group the data on your chart. In our chart above, Sprint is set for the Chart by value, and Status for the Group by value. You can see each vertical bar represents the Sprint, and the groups within each bar represent the Status of the issues in those Sprints.
The options are:
-
Custom JQL - group the chart by writing a JQL statement directly in the gadget/macro
-
Saved filter - group the chart by selecting an existing Jira filter
-
Fields - group the chart by any custom field, system field, or field that comes from another app
5: Calculations
Click this button to open up the Calculations tab in Custom Charts. Here, you can choose which data point to calculate and how to measure it. This will be the primary calculation. You can also add additional calculations to your chart.
The options are:
-
Count - displays a count of issues or projects in the Chart by and Group by segments. The app defaults to issue count
-
Sum - adds up a number field of your choice in the Chart by and Group by segments
-
Average - takes the average of a number field of your choice in the Chart by and Group by segments
The chart above has issue count as the calculation.
6: Live preview
Gives chart creators the ability to see a preview of the chart before saving the gadget/macro to the dashboard/page. Most edits made to the chart can be seen here.
7: Chart settings
Customize the look and feel of your charts. Here, you can adjust chart colors, add a chart title, adjust number and date formats, and more (learn more here).
8: Save button
The Save button will save the chart and any changes to the Dashboard.
In Confluence, users will see the Insert button instead.