What does this gadget offer?
The Grouped Filter Results gadget can be used to calculate sums of multiple fields while the source issues are grouped by one custom field.
Configuration
Add a custom title to the gadget for easier identification. If nothing is set, the title will be generated by combining the gadget name and the selected filter/ JQL.
Select whether you want to use a predefined JQL Filter or a custom JQL to get the issues.
Add fields to be displayed as columns and reorder them using drag and drop.
The sum/ average of a field will only be displayed, if a calculation rule has been created.
If there are multiple calculation rules for a single field, they all are selectable from the dropdown list.
The field name will be written in parentheses behind the rule name.
If there are multiple calculation rules for a single field, they all are selectable from the dropdown list.
The field name will be written in parentheses behind the rule name.
Select a field that will be used to group the results on the Y-axis.
Grouping by name instead by ID
SINCE VERSION 3.6.0
When selecting one of the following fields, it is possible to group by their name instead of the ID:
Version fields (Affected version, Fix version)
Components field
Option select custom fields
By default, the values will be grouped by their ID, meaning that there might be several options that have the same name (e.g. 2 components from different projects) but since they don't have the same ID in the database, they will be treated as two different values.
When checking the checkbox, options with the same value will be treated as one option, even though they are saved as different values in the database.
Choose how many results you want to display on your dashboard.
The following additional options are available:
Option | Description |
---|---|
Which time period do you want to display as default? | If you have chosen to group the data by a date or date time field (e.g. “Due date” or “Created”), you can set a default time period for the displayed data when the gadget is loaded or refreshed. You can choose between:
|
Which default for the date aggregation level do you choose | If you have chosen to group the data by a date or date time field (e.g. “Due date” or “Created”), you can set a default time period for the displayed data when the gadget is loaded or refreshed.
|
You can choose between:
Never
Every 15 Minutes
Every 30 Minutes
Every 1 Hour
Every 2 Hours
If Never is selected, the gadget will only be refreshed on page reload.
View mode
Sorting
The colums can be sorted by clicking on the small arrows next to each colum header.
The gadget displays an additional filter at the top when a date field is selected in the configuration.
It contains the following options:
Option | Description |
---|---|
Date filter | The drop-down menu contains the options in the following order:
Initially, it is pre-populated with the value set in the configuration and the data is displayed accordingly. |
Date picker | The picker allows you to override the "Date filter" selection. You can select the start and end dates of the aggregated data by clicking first on the start date and then on the end date. To enter your chosen date, click next to the expanded calendar.
|
Date grouping | The selector determines how the data is grouped in the columns/rows of the table. The drop-down menu contains the following options:
Initially, it is pre-populated with the value set in the configuration and the data is displayed accordingly.
|
Info icon | The tooltip displays information about the data displayed in the gadget. |
You can choose between the overall ∑ total or the total of the ∑ page. Or you can choose between the Ø total or the Ø page, if you selected average fields.
Related Use Cases
Title | Description | Gadget |
---|---|---|
Comparison of Budget and Total Costs | Compare previous year's budgets and costs on a quarterly basis. | Grouped Filter Results |