This documentation relates to version 1.11 of Rich Filters for Jira Dashboards. Documentation for previous versions is available via the documentation index.

The Rich Filter Statistics Gadget

The Rich Filter Statistics Gadget displays the collection of issues grouped by a specific field/criteria. It is similar to 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 furthered filtered using Rich Filter Controller gadgets;
  • the gadget itself can further refine the results by applying a gadget-specific JQL that we call “working query”;
  • the gadget can break down the results by an issue field or by a smart filter, or by time series;
  • the gadget can also use a date field in order to break down the results by Hour, Day, Week, Month, Quarter or Year;
  • the gadget can display multiple outputs at the same time (such as Issue Count and Story Points);
  • the gadget’s title can be customized.

Using Jira Service Desk?

You should have a look at our Rich Filters for Service Desk Dashboards app to see how to display statistics based on Service Desk fields – Customer Request Type and Organizations, compute values based on Service Desk SLA fields, or display time series based on Service Desk SLA fields.

Rich Filters for Service Desk Dashboards is an extension of the Rich Filters for Jira Dashboards app. This extension needs to be installed and licensed separately and adds functionality specific to Jira Service Desk on top of the existing rich filters.

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:


Statistics on date fields and time series

The gadget can also display statistics based on date fields and time series. Some settings are relevant and will be displayed only if the Statistic Type is a date or date/time field or a time series (i.e. Time Intervals, Number of Intervals, Display Period). At the same time, the Sort By and Maximum Rows are relevant and will be displayed only for statistic types which are not date, date/time or time series. 

Edit the gadget configuration as described in the following table:

Setting Description

Title

Optionally, you can customize the title of the gadget. If left blank, the default title will be 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 filter you need.

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

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 the rich filter of the gadget using the Rich Filter option in the menu at the top right of the gadget.

Working Query

The working query is a JQL query that is combined with the base filter of the rich filter before searching for issues. The working query is optional: if left empty, only the base Jira filter and the quick filters affect the issues displayed.

Statistic Type

This setting is mandatory. Select the issue field or the smart filter on which the issues will be grouped. You can also select Advanced - Time Series in order to build statistics based on time series.

Sort By

Does not apply to date and date/time fields or to time series

Select how to sort the values of your Statistic Type:

  • Total: this will sort by the value of each each Statistic Type group (if there are multiple value columns, the first one is used for sorting).
  • Alphabetical: this will use alphabetical order for the Statistic Type groups.
  • Natural: this will use 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.

Time Intervals

Applies only to date and date/time fields or to time series

The length of the time intervals to be used for statistics. It can be: Hourly (only for date+time fields), Daily, Weekly, Monthly, Quarterly, or Yearly.

Number of Intervals

Applies only to date and date/time fields or to time series

The number of time intervals to be displayed in the statistics gadget.

Display Period

Applies only to date and date/time fields or to time series

Depending on the date field you use, you can select the period you wish to represent in the statistics gadget:

  • Past
  • Future
  • Past & Future

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 an 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 easily see all the issues that are due soon or Past & Future to also see if there are overdue issues.

Maximum Rows If set, limits the maximum number of result rows to display.
Show Percentage Bars If checked, the gadget displays the proportion represented by each statistic value relative to the total as a bar chart.
Show Totals
If checked, the gadget displays the total value/s.

Values

Does not apply if the Statistic Type is Time Series

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

There are five kinds of possible values:

  • 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 all issues in each group.
  • Σ Time Tracking: the same as Time Tracking but for each issue it also includes the values in its sub-tasks.
  • 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 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.

In Jira, numeric fields can also store negative values. If the Show percentage bars checkbox is checked, the Rich Filter Statistics Gadget treats the negative values as zero.

Time Series

Applies only if the Statistic Type is Time Series

Select the time series to be displayed. For each selected time series, the gadget displays a new column with values.