The Rich Filter Two Dimensional Statistics Gadget
- Bogdan Butnaru
- Praveena Manohar
- Cristian Oancea
Contents:
About the Rich Filter Two Dimensional Statistics Gadget
The Rich Filter Two Dimensional Statistics gadget is a two-dimensional version of the Rich Filter Statistics Gadget. It allows grouping issues on two axes and computes statistics for each combination of values. It is similar to Jira’s built-in Two Dimensional Filter Statistics gadget, but it is based on a rich filter instead of a Jira saved search and thus adds several new features:
the collection of issues used for the statistics can be further filtered using Rich Filter Controller gadgets;
the gadget itself can further refine the results by applying a gadget-specific JQL that we call a working query;
the gadget can break down the results by a field or by a Smart Filter;
the gadget can also use a date field to break down the results by Hour, Day, Week, Month, Quarter or Year;
the value type displayed by the gadget can be customized (for instance, to show the sum of Story Points instead of the Issue Count);
the gadget can display custom ratios;
the gadget’s title can be customized.
Rich Filter Extensions
Rich filter extensions are separate Jira apps installed on top of the Rich Filters for Jira Dashboards app to extend the rich filters and rich filter gadgets with new specific functionality.
New statistic options are available if you add any of these extensions:
Rich Filters::Time Tracking Dashboards allows you to display statistics based on work log attributes – Worklog Author and Worklog Time Spent
Rich Filters: Service Desk Dashboards allow you to display statistics based on Service Desk fields—Customer Request Type and Organizations—or compute values based on Service Desk SLA fields.
Configuring the Rich Filter Two Dimensional Statistics Gadget
Add a new or edit an existing Rich Filter Two Dimensional Statistics gadget in your Jira dashboard. The configuration form of the gadget will be displayed:
Edit the gadget configuration as described in the following table:
Setting | Description |
|---|---|
Title | You can optionally customize the gadget's title. If left blank, the default title will be 2D Rich Filter Statistics. |
Rich Filter | Select the rich filter the gadget will use. Click the Rich Filter button to display the list of rich filters; you can either scroll through or use the search box to find the desired filter. The gadgets’ configuration forms only show the rich filters you can view. For details, see the section on permissions. The link in the description line below the Rich Filter button opens a new page with the configuration of the selected rich filter. Also, when the gadget is in display mode, you can navigate directly to its rich filter using the Rich Filter option in the menu at the top right of the gadget. |
Working Query | The working query is a JQL query combined with the rich filter's base filter before searching for issues. The working query is optional: if left empty, only the base and quick filters affect the issues displayed. |
Because this gadget groups issues on two criteria, some settings must be configured in pairs, one setting for each dimension. In the gadget configuration form, these settings are grouped under the headings X Axis (which defines how the columns behave) and Y Axis (for the rows). Below, we describe the breakdown settings only once. | |
Statistic Type | Select the issue field or the smart filter on which the issues will be grouped. This setting is mandatory for both axes and specifies the criteria on which the issues will be grouped. For each axis, there are two types of Statistic types:
|
Statistics on option issue fields or smart filters
The following statistics settings are applicable when the selected Statistic type is an option issue field (e.g., Priority, Status, select custom fields, etc.) or a smart filter:
Setting | Description |
|---|---|
Sort by | Select how to sort the values of your Statistic type:
|
Reverse sort order | If checked, the sort order is reversed. |
Maximum Rows/Columns | These settings limit the maximum number of rows and columns to display. |
Show Totals Row/Column | If checked, the gadget displays the total value/s on either axis. |
Values | Select the value to be computed for each Statistic type group. The following value types are available:
|
Statistics on date and date time fields
The following statistics settings are applicable when the selected Statistic type is a date or a date time field:
Setting | Description | ||
|---|---|---|---|
Aggregation periods | Select the periods on which the issues will be grouped, according to their values for the date or date time field selected as Statistic type. The available options are Hours, Days, Weeks, Months, Quarters, and Years. | ||
Time range | Together with its subsettings, this specifies the total period for the results to be computed. The time range subsettings depend on the option selected in the Time range drop-down as described below. | ||
Time range | Time range subsetting | Description | |
Number of periods | Number of periods | Enter a number of periods. The time range corresponds to the specified number of consecutive aggregation periods. | |
Direction | Select how the periods are positioned relative to the current period. The possible options are:
| ||
Between dates | Start date End date | Enter the two dates that define the limits of the time range (both specified dates are inclusive). The inputs can be selected from a date picker or entered manually as a calendar date (" | |
Contextual options | These are predefined Time range options that depend on the selected Aggregation period. Possible options are, This year, Last year, This quarter, Last quarter, This month, Last month. | ||
Reverse sort order | If checked, the default chronological order is reversed. | ||
Show Totals Row/Column | If checked, the gadget displays the total value/s on either axis. | ||
Values | Select the value to be computed for each Statistic type group. The following value types are available:
| ||