The Rich Filter Statistics Gadget

The Rich Filter Statistics Gadget

Contents:

About the Rich Filter Statistics gadget

The Rich Filter Statistics gadget displays the collection of issues grouped by a specific field/criteria. It resembles Jira’s built-in Issue 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 called working query;

  • the gadget can group the issues by an issue field or by a smart filter;

  • the gadget can group the issues by the values of a date or date time field to compute daily, weekly, monthly, quarterly, or yearly statistics;

  • the gadget can display multiple result types at the same time (such as Issue Count and Story Points);

  • the gadget can display custom ratios;

  • the gadget can display one or more time series;

  • the user can change the sorting order by clicking on a column name;

  • the gadget can display the data as a chart; the user can switch between the table view and the chart view by clicking on an icon;

  • the content of the gadget can be exported to PDF, Excel (.xlsx), and CSV formats.

Example 1: Issue Count and Story Points aggregated by the issue field Priority:

Issue Count and Story Points aggregated by Priority.png

Example 2: Issue Count and Story Points aggregated by a smart filter named High-level Status:

The labels and colors displayed for High Level Status come from the clauses defined in this smart filter's configuration.

Configuring the Rich Filter Statistics gadget

Add a new or edit an existing Rich Filter Statistics gadget in your Jira dashboard. The configuration form of the gadget will be displayed:

Edit the gadget configuration as described below:

Setting

Description

Setting

Description

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 more details, check the Rights and Permissions page.

Working Query

The working query is an additional JQL query that is permanently applied on top of the base Jira filter and any active quick filters in the controller to further filter the issues the gadget will work with. The working query is optional: if left empty, only the base Jira filter and the quick filters affect the issues used by the gadget.

Statistic type

Select the issue field or the smart filter on which the issues will be grouped. The drop-down list includes the smart filters defined in the selected rich filter:

High-level Status.png

 

The gadget supports several types of breakdown configuration, depending on the selected Statistic type:

  • Statistics on option fields (e.g., Priority, Status, select custom fields, etc.) or smart filters

  • Statistics on date or date time fields

  • Statistics on time series

These options are further detailed in the sections below. 

Statistics on option fields or smart filters

The following settings are applicable when the selected Statistic type is an option field (e.g., Priority, Status, select custom fields, etc.) or a smart filter:

Setting

Description

Setting

Description

Sort by

Select how to sort the values of your Statistic type:

  • Total: This will be sorted by the value computed for each statistical type group (if multiple value columns exist, the first one will be used for sorting).

  • Alphabetical: This will use alphabetical order for the statistical type groups.

  • Natural: This will use the native sorting order of the issue field or smart filter selected as Statistic type, i.e., the order configured for the field or smart filter's options. This sorting option is available only for the issue fields Priority, Status, and Issue Type and for smart filters.

Reverse sort order

If checked, the sort order is reversed.

Maximum rows

If set, limit the number of result rows to display.

The user can still display all the computed rows by clicking on the number of rows in a rounded rectangle at the bottom right of the gadget.

Show percentage bars

If checked, the gadget displays a bar chart for each statistic value:

  • for all value types other than custom ratios, the proportion of each value relative to the total;

  • for custom ratios, the proportion corresponding to the ratio.

Show totals

If checked, the gadget displays a row with the totals for each selected value.

Values

Select the values to be computed for each Statistic type group. You can select up to 10 values at a time.

The following value types are available:

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

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

  • Numeric: computes the sum of a numeric field for the issues in each group. For instance, when using Jira Software, the gadget can show the number of Story Points for each Statistical type group.

  • Custom values: displays a custom value configured in the rich filter (aggregation formula, display options, etc.).

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

Need support? Create a request with our support team.

Copyright © 2005 - 2025 Appfire | All rights reserved.