2.4Building Dashboards with JQL

Dashboards combine multiple JQL queries into a visual overview. Here are the essential dashboard widgets for a QA team.

Sprint Quality Dashboard

Widget	JQL	Display Type
Open Bugs by Priority	project = SHOP AND type = Bug AND status not in (Done, Closed)	Pie chart
Bugs Created vs Resolved (30 days)	Created: project = SHOP AND type = Bug AND created >= -30d Resolved: ... AND resolved >= -30d	Line chart
Flaky Test Backlog	labels = flaky-test AND resolution = Unresolved	Issue list
Test Execution This Sprint	type = "Test Execution" AND sprint in openSprints()	Statistics
Unassigned Bugs	project = SHOP AND type = Bug AND assignee is EMPTY AND resolution = Unresolved	Issue list

Release Readiness Dashboard

-- Tests not yet executed for the release
type = "Test" AND fixVersion = "2.4.0" AND "Test Status" != "Passed"

-- Open blockers for the release
project = SHOP AND type = Bug AND priority = Blocker
AND fixVersion = "2.4.0" AND resolution = Unresolved

-- Stories without test coverage
project = SHOP AND type = Story AND fixVersion = "2.4.0"
AND NOT issueFunction in linkedIssuesOf("type = Test AND status = Passed")