Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this sectionContents:

Table of Contents
stylenone

...

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 in order 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.

...

Tip

Rich Filter Extensions

Rich filter extensions are separate Jira apps that can be 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 the these extensions:

...

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

Optionally, you You can optionally customize the gadget's title of the gadget. If left blank, the default title will be 2D Rich Filter Statistics.

Rich Filter

Select the rich filter the gadget will use.

Click on 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 you need.

Info

The gadgets’ configuration forms only show the rich filters you are allowed to can view. See For details, see the section on permissions for details.

Tip

The link in the description line below the Rich Filter button opens a new page with the configuration of the selected rich filter.

Image RemovedImage Added

Also, when the gadget is in display mode, you can navigate directly to the its rich filter of the gadget using the Rich Filter option in the menu at the top right of the gadget.

Image RemovedImage Added

Working Query

The working query is a JQL query that is combined with the base filter of the rich rich filter's base filter before searching for issues. The working query is optional: if left empty, only the base base filter and the 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:

  • a. Option issue fields (e.g., Priority, Status, select custom fields, etc.) and Smart Filters 

  • b. Date and date time issue fields 

Image RemovedImage Added
Note

For each axis, all the following configuration options depend on the selected Statistic type.

...

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:

  • Total: this will sort sorts by the value of each Statistic type group.

  • Alphabetical: this will use Uses alphabetical order for the Statistic type groups.

  • Natural: this will use Uses the issue field’s or smart filter’s native sorting order, i.e., the order that has been configured for the options of each field or smart filter.

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: 

  • Issue Count: computes the number of issues in each group.

  • Numeric: computes the sum of a numeric field for all issues in each group. For instance, if using Jira Software, the gadget can show how many the number of Story Points there are for each Statistic type group. 

  • Σ Numeric: the same as Numeric, but for each issue it also includes the values in its sub-tasks for each issue.

  • Time Tracking: computes the sum of one of the time-tracking fields (i.e., Original Estimate, Remaining Estimate, Time Spent) for all issues in each group.

  • Σ Time Tracking:This is the same as Time Tracking, but for each issue, it also includes the values in its sub-tasks.

  • Custom Values: computes values based on the configuration of a custom value – label, such as abel, total formula, formatting, and JQL filter.

  • Custom Ratios: displays a custom ratio as configured in the rich filter (percentage or ratio).

Image RemovedImage Added

...

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 the 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 time span period for which the results will 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:

  • Past – the time range includes past periods and the current period

  • Future – the time range includes the current period and future periods

  • Past & Future – the time range includes past periods, the current period, and future periods, with the current period in the middle of the range

Tip

Fields like Created or Resolved always contain values that are in the past. Therefore you should always select Past for these fields as you will never find any issue created or resolved in the future.

Fields like Due Date contain values that can be both in the past and in the future. For this field, it is more useful to select Future in order to see statistics for the issues that are due soon , or Past & Future to also see the statistics for overdue issues.


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 ("yyyy/MM/dd" or "yyyy-MM-dd") or as a time relative to the present (e.g. "-5d", "4w 2d").

Contextual options


These are predefined Time range options which 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: 

  • Issue Count: computes the number of issues in each group.

  • Numeric: computes the sum of a numeric field for all issues in each group. For instance, if using Jira Software, the gadget can show how many the number of Story Points there are for each Statistic type group. 

  • Σ Numeric: the same as Numeric, but for each issue it also includes the values in its sub-tasks for each issue.

  • Time Tracking: computes the sum of one of the time-tracking fields (i.e., Original Estimate, Remaining Estimate, Time Spent) for all issues in each group.

  • Σ Time Tracking:This is the same as Time Tracking, but for each issue, it also includes the values in its sub-tasks.

  • Custom Values: computes values based on the configuration of a custom value – label, such as abel, total formula, formatting, and JQL filter.

  • Custom Ratios: displays a custom ratio as configured in the rich filter (percentage or ratio).

Image RemovedImage Added