Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 10
UI Text Box
sizemedium
typeinfo

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.

Image Removed

Image Added

Configuration


UI Expand
titleWhat is the name of your gadget?Gadget Title

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.

UI Expand
titleWhich issues do you want to analyze?Issue filter

Select whether you want to use a predefined JQL Filter or a custom JQL to get the issues.

UI Expand
titleWhich fields would you like Fields to display?

Add fields to be displayed as columns and reorder them using drag and drop.

UI Text Box
typenote

The sum/ average of a field will only be displayed, if a calculation rule has been created.

Excerpt Include
Filter Results gadget (by sumUp)
Filter Results gadget (by sumUp)
nopaneltrue

UI Expand
titleHow do you want to group the results?Group By

Select a field that will be used to group the results on the Y-axis.

UI Text Box
typeinfo

Grouping by name instead by ID

Status
colourYellow
titlesince 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.

Image Modified

UI Expand
titleHow many rows do you want to display per page?Number of Results

Choose how many results you want to display on your dashboard.

The following additional options are available:

If Never is selected, the gadget will only be refreshed on page reload

.
UI Expand
titleChoose additional options
Excerpt

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: 

  • Current week
  • Current month
  • Current quarter
  • Current year
  • All-time

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.

  • Daily
  • Weekly
  • Monthly
  • Quarterly
  • Yearly
UI Expand
titleRefresh Intrerval:
Refresh Interval

Specify how often the gadget should be refreshed.

 You can choose between: 

  • Never

  • Every 15 Minutes

  • Every 30 Minutes

  • Every 1 Hour

  • Every 2 Hours

Info

Image RemovedView mode 

UI Expand
titleSorting
Note
titleSorting

The colums can be sorted by clicking on the small arrows next to each colum header. 

cqllabel = "grouped-filter-resuls" and space = currentSpace()The gadget displays an additional filter at the top when a date field is selected in the configuration

.

Image Removed

It contains the following options:

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.

Image Removed

UI Expand
titleFilter bar
UI Text Box
typenote
Excerpt

Option

Description

Date filter

The drop-down menu contains the options in the following order:

  • Current week
  • Current month
  • Current quarter
  • Current year
  • All-time
UI Text Box
typenote

Initially, it is pre-populated with the value set in the configuration and the data is displayed accordingly. 

Date picker

UI Text Box
typetip
Note

To enter your chosen date, click next to the expanded calendar.

UI Text Box
typenote
  • If the date range is cleared, the "Date filter view" reverts to the previous configuration. 
  • If the date range is not customized, the appropriate date filter will be displayed according to the option. For example, the period selection would display "01/Jan/24-31/Dec/24" if the “Current year” option is selected. If the date range is adjusted, the Date Filter View changes to “Customized”.

Date grouping

UI Text Box
typetip

The selector determines how the data is grouped in the columns/rows of the table.

The drop-down menu contains the following options:

  • Daily shown as separate dates. 
  • Weekly shown as W1, W2, W3,...
  • Monthly shown as M1, M2, M3,...
  • Quarterly shown as Q1, Q2, Q3, Q4
  • Yearly shown as Y/22, Y/23, Y/24, ...
UI Text Box
typenote

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.

UI Expand
title∑ total
You can choose between theoverall ∑ total or thetotal of the ∑ page. Or you can choose between the Ø total or the Ø page, if you selected average fields. 

Image Removed

Related Use Cases

Page properties report


Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue