Configuring Custom Values
- Cristian Oancea
- Praveena Manohar
- Dan Mihalache
Contents:
About Custom Values
Custom values are user-defined outputs that can be used in rich filter gadgets. They are available as columns in views and as values in gadgets alongside the Jira fields. They provide support for custom aggregation formulas (sum, average, minimum, and maximum, with optional JQL filtering of contributing issues) and custom results display (label, color, and format). Custom values can be based on Issue Count or numeric and time-tracking fields.
Below is an example of a Rich Filter Statistics gadget that displays, by assignee, the following custom values: the sum of the story points of the resolved issues, the sum of the time spent for support issues, the average time spent (displayed in hours) and the maximum remaining estimate for the unresolved issues.
Custom Values' Key Attributes
The Custom Values section of your rich filter allows you to add new custom values and view their configuration.
The key attributes of a custom value are:
Attribute | Description |
|---|---|
Name | Each custom value has a name used to identify and display it. The name is mandatory and must be unique among the custom values within the rich filter. |
Color | The selected color will be used to display the value in some of the rich filter gadgets. |
Base value | The value on which your custom value is based is selected among Issue Count or numeric and time-tracking fields. |
Total Formula | The formula used for aggregation. The possible options are sum, average, minimum, and maximum. |
Display | The display format of the custom value. The available options are
What's the difference between maximum 2 and exactly 2 decimals? If you select exactly 2 options, the value will always be displayed in 2 decimals. This is achieved by rounding to 2 decimals if more than 2 are available (e.g., 23.4567 → 23.46) or padding with zeros up to a total of 2 decimals if fewer than 2 are available (e.g., 23.4 → 23.40). Selecting the maximum 2 option will display the value with 0, 1, or 2 decimals. This is achieved by rounding to 2 decimals if more than 2 are available (e.g., 23.4567 → 23.46) and leaving the value as it is if 2 or fewer decimals are available (e.g., 23.4 → 23.4). |
JQL | You can optionally define a JQL query to filter the issues contributing to the custom value. Only the issues satisfying this query will be taken into account when calculating the custom value. |
Adding & Editing Custom Values
The Custom Values section of your rich filter allows you to perform the following operations:
To achieve this: | Do the following: |
|---|---|
Add a new Custom Value | Click on the Create custom value button at the top-right of the page. Type a name, select a color, a base value, a total formula, and a display format, and optionally type a JQL query, then click the Create button. You can add up to 50 custom values in each rich filter. |
View or edit a Custom Value. | Depending on your rights, click on any custom value to view or edit its configuration. |
Reorder the Custom Values | Hover over the vertical “grid” icon, then drag and drop the custom value up or down to the new position. |
Delete a Custom Value | Click on the delete icon located at the right of the custom value. |
Computed Custom Values
Computed custom values are a special case of custom values having a computed base value. Like any other custom value, computed custom values can be used in views and rich filter gadgets.
The Rich Filter app provides two computed duration custom values:
Issue age / resolution time - predefined duration value calculated as the time elapsed between the resolution time (or now for unresolved issues) and the created date
Custom duration - duration value calculated as the time elapsed between any two date/date time fields or between a date/date time field and now
These options are further detailed in the sections below.
Issue age/resolution time
Issue age / resolution time is a predefined computed duration value based on the issue created and resolved dates. The issue age / resolution time is calculated as:
for unresolved issues – the time elapsed between now and the created date (issue age)
for resolved issues – the time elapsed between the resolution date and the created date (resolution time)
To create a custom value based on the issue age / resolution time, select the Issue age / resolution time option in the Base value drop-down menu. The option is available under the Duration (computed) category:
The Total formula and JQL fields are the same as any other custom value described in Custom Values' Key Attributes.
The display format field is duration-specific and allows you to choose between Days and Hours.
Custom duration
Custom duration is a computed duration value, calculated as the time elapsed between any two date/date-time fields or between a date/date-time field and now.
Select the Custom Duration option in the Base Value drop-down menu to create a custom value based on a custom duration. The option is available under the Duration (computed) category:
Next, select the Start and End, which can be a date/date-time field or the Current time. If the selected date/date-time field can be empty, an extra checkbox becomes available in the selection window, allowing the current day to be used instead of an empty value:
The Total formula and JQL fields are the same as any other custom value described in Custom Values' Key Attributes.
The display format field is duration-specific and allows you to choose between Days and Hours.
If one of the selected values for the start or end date is of type date, the display format is automatically set to Days. In this case, the computed value is a non-fractional number of days.
Lead time
Lead Time is an important concept, defined as the average resolution time for the resolved issues. To compute the lead time, create a custom value based on issue age / resolution time and choose the average formula. Use the JQL to eliminate all those issues that are not yet resolved:
Using Custom Values in Rich Filter Gadgets
Custom values can be added to views displayed as columns in Rich Filter Results gadgets or as values in the Rich Filter gadgets displaying aggregated issue data.
Below are some examples of rich filter gadgets configured to display custom values:
Rich Filter Results gadget displaying a view that contains a custom value based on Time Spent and formatted in hours:
Look at The Rich Filter Results Gadget documentation page to find out how to configure the gadget.
Rich Filter Simple Counter gadget displaying four custom values:
Look at The Rich Filter Simple Counter Gadget documentation page to find out how to configure the gadget.
Rich Filter Statistics gadget displaying four custom values aggregated by assignee:
Look at the Rich Filter Statistics Gadget documentation page to learn how to configure the gadget.
Rich Filter Two Dimensional Statistics gadget displaying a custom value named Support Time Spent aggregated by the issue field Priority and a smart filter named Team:
Check the Rich Filter Two Dimensional Statistics Gadget documentation page to see how to configure the gadget.
Rich Filter Flexi Charts gadget displaying a bar chart of a custom value named Resolved Story Points by assignee:
Check the Rich Filter Flexi Charts Gadget documentation page to see how to configure the gadget.