Exclude items with Zero metric values

You need to exclude empty dates from your chart in Jira? Performance Objectives: Charts for Jira offers diverse chart result formatting choices, including ‘Exclude Items with Zero Metric Values‘ feature. This applies to Date and Text type fields for ‘Display By,’ ‘Group by,’ and ‘Stacked by’ display settings. It effectively filters out empty records from the x-axis within your specified date range.

In most scenarios, it’s employed to calculate average values by excluding non-working days (dates lacking values).

Exclude Empty Dates in Jira with Performance Objectives app

Experience the distinction on the chart’s comprehensiveness by excluding empty dates. We’ve provided two images for comparison. On the left, data for each date within a calendar month is shown. On the right, with “Exclude Items with Zero Metric Values” active, only dates with values are displayed. Witness the power of this feature in refining your chart representations:

In our example chart, the “Exclude Items with Zero Metric Values” feature is activated for the ‘Number of issues’ metric with the “Created” date field set for the “Display by” option.

Jira Date Field Types Compatible With Exclude Items with Zero Metric Values

Discover a compilation of Jira Standard, Jira Service Management, Performance Objectives Dynamic, and Jira Custom fields with the Date field type. These fields are compatible with the “Exclude Items with Zero Metric Values” feature, offering improved chart visualizations on your Jira dashboard.

Field Name
Usage
Compatibility

1.
Actual end
calendar_month
F
check

2.
Actual start
calendar_month
F
check

3.
Approval Completed
calendar_month
F
check

4.
Approval Created
calendar_month
F
check

5.
Assignee change date
calendar_month
F
lock_open
check

6.
Created
calendar_month
F
check

7.
Due date
calendar_month
F
check

8.
Date of first response
calendar_month
F
check

9.
First date in status
calendar_month
F
check

10.
First date flagged
calendar_month
F
check

11.
First date in assignee
calendar_month
F
check

12.
First sprint start date
calendar_month
F
check

13.
First work log
calendar_month
F
check

14.
Flagged change date
calendar_month
F
check

15.
Last date in status
calendar_month
F
check

16.
Last date flagged
calendar_month
F
check

17.
Last date in assignee
calendar_month
F
check

18.
Last dev commit date
calendar_month
F
check

19.
Last sprint end date
calendar_month
F
check

20.
Last work log
calendar_month
F
check

21.
Last viewed
calendar_month
F
check

22.
Planned end
calendar_month
F
check

23.
Planned start
calendar_month
F
check

24.
calendar_month
F
check

25.
Resolved
calendar_month
F
check

26.
Satisfaction date
calendar_month
F
check

27.
Start date
calendar_month
F
check

28.
Status Category changed
calendar_month
F
check

29.
Status change date
calendar_month
F
lock_open
check

30.
Target end
calendar_month
F
check

31.
Target start
calendar_month
F
check

32.
Updated
calendar_month
F
check

33.
Work logged
calendar_month
F
check

Jira Text Field Types Compatible With Exclude Items with Zero Metric Values

Here’s a list of Jira Standard, Jira Service Management, Performance Objectives Dynamic, and Jira Custom fields with the Text field type, compatible with the “Exclude Items with Zero Metric Values” feature:

Field Name
Usage
Compatibility

1.
Affects versions
abc
F
check

2.
Approval Decision
abc
F
check
3.
Affected hardware
abc
F
check
4.
Approver groups
abc
F
check
5.
Components
abc
F
check

6.
Change reason
abc
F
check
7.
Change risk
abc
F
check
8.
Change type
abc
F
check
9.
Epic Link
abc
F
check
10.
Fix versions
abc
F
check
11.
Flagged
abc
F
check
12.
Impact
abc
F
check
13.
Investigation reason
abc
F
check
14.
Issue color
abc
F
check
15.
Issue key
abc
F
check
16.
Issue summary
abc
F
check
17.
Issue type
abc
F
check
18.
Labels
abc
F
check
19.
Major incident
abc
F
check
20.
Operational categorization
abc
F
check
21.
Organizations
abc
F
check
22.
Parent
abc
F
check
23.
Priority
abc
F
check
24.
Project
abc
F
check
25.
Pending reason
abc
F
check
26.
Product categorization
abc
F
check
27.
Resolution
abc
F
check
28.
Request type
abc
F
check
29.
Responders
abc
F
check
30.
Satisfaction
abc
F
check
31.
Severity
abc
F
check
32.
Source
abc
F
check
33.
Sprint
abc
F
check
34.
Status
abc
F
check
35.
SLA Is Breached
abc
F
check
36.
SLA Is Paused
abc
F
check

38.
abc
F
check
39.
abc
F
check
40.
abc
F
check
41.
Status (history)
abc
F
lock_open
check

42.
Urgency
abc
F
check
43.
Work category
abc
F
check

To access a comprehensive compilation of supported metrics and fields, kindly refer to the Configuration Overview.

For an exploration of Performance Objectives: Charts for Jira app’s robust features and customization options, visit our comprehensive User Guide.

Start your 30 days free trial of Performance Objectives: Charts for Jira from Atlassian Marketplace.

logo gradient blue marketplace