Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Version published after converting to the new editor

In this section:

  1. About the Rich Filter Two Dimensional Statistics gadget
  2. Configuring the Rich Filter Two Dimensional Statistics gadget
    1. Statistics on option fields or smart filters
    2. Statistics on date fields
    3. Statistics on time series
  3. Quick charts in the Rich Filter Two Dimensional Statistics gadget

...

SettingDescription
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.

Info

The gadgets’ configuration forms only show the rich filters you are allowed to view. See the Rights and Permissions documentation page for details.


Working queryThe working query is an additional JQL query which 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.
Two breakdowns need to be configured, one horizontal and one vertical. 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. The drop-down list includes the smart filters defined in the selected rich filter:

Note

For each of the two breakdowns (horizontal and vertical) there are several types of configuration, depending on the selected Statistic type:

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

b. Statistics on date or date time fields

c. Statistics on time series

These options are further detailed in the sections below. 


...

SettingDescription
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: Days, Weeks, Months, Quarters, Years, Auto.

Tip

If the Auto option is selected, the aggregation periods and time range are adjusted dynamically to produce the most granular yet complete statistics (i.e. with the appropriate aggregation period so that all the relevant issues are included).


Time range





Together with its subsettings, this specifies the total time span for which the statistics should be computed. 

The time range subsettings depend on the option selected in the Time range drop-down as described below.

Time rangeTime range subsettingDescription

Number of periods

Number of days / weeks etc.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

From / To

Enter the two dates that define the limits of the time range (both specified dates are inclusive).

The inputscan be selected from a date picker or entered manually as a calendar date ("yyyy/MM/dd" or "yyyy-MM-dd").

All dates


If selected, the time range is determined dynamically to include all the relevant issues (from the first date to the last date occurring in the values of the issues).

Info

All dates is the only possible Time range option if the selected Aggregation period is Auto.


Contextual options


These are predefined Time range options which depend on the selected Aggregation period.

Possible options are: This year, Last year, This quarter, Last quarter, This month, Last month. 

Reverse sort orderIf checked, the default chronological order is reversed.
Show totalsIf checked, the gadget displays the total values for the corresponding breakdown.
Value

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.
  • 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, if using Jira Software, the gadget can show how many Story Points there are for each Statistic type group.
  • Custom values: displays a custom value as configured in the rich filter (aggregation formula, display options, etc.).
  • Custom ratios: displays a custom ratio as configured in the rich filter (percentage or ratio).

...

SettingDescription
Aggregation periods

Select the periods on which the issues will be grouped, according to the date or date time field on which the selected time series is based.

The available options are: Days, Weeks, Months, Quarters, Years, Auto.

Tip

If the Auto option is selected, the aggregation periods and time range are adjusted dynamically to produce the most granular yet complete statistics (i.e. with the appropriate aggregation period so that all the relevant issues are included).


Time range





Together with its subsettings, this specifies the total time span for which the statistics should be computed. 

The time range subsettings depend on the option selected in the Time range drop-down as described below.

Time rangeTime range subsettingDescription

Number of periods

Number of days / weeks etc.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 time series based on 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 time series based on 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

From / To

Enter the two dates that define the limits of the time range (both specified dates are inclusive).

The inputscan be selected from a date picker or entered manually as a calendar date ("yyyy/MM/dd" or "yyyy-MM-dd").

All dates


If selected, the time range is determined dynamically to include all the relevant issues (from the first date to the last date occurring in the values of the issues).

Info

All dates is the only possible Time range option if the selected Aggregation period is Auto.


Contextual options


These are predefined Time range options which depend on the selected Aggregation period.

Possible options are: This year, Last year, This quarter, Last quarter, This month, Last month. 

Reverse sort orderIf checked, the default chronological order is reversed.
Show totalsIf checked, the gadget displays the total values for the corresponding breakdown.
Value

The gadget automatically fills-in the Value field with the base value of the selected time series.

...