How to create a useful dashboard in Jira

[Sha Melo]

I am looking for examples of known useful dashboards and filters that will help visualize Agile team metrics.

What are common metrics that most Agile teams want to be able to review:

• Sprint burndown
• Sprint Status (remaining days)
• Sprint work (committed vs completed)
• Features or Epics in sprint (completed vs remaining)

And from a project level:

• completed points per epic
• remaining points per epic
• estimated remaining sprints in total
• estimated remaining sprints per epic
• count of new tickets created - maybe week over week?
• due dates for testing of each epic

Does anyone have examples of filters to use, or even better, an example of a dashboard that is useful? Thanks.

[Sachin · Accepted solution]

Hello @Sha Melo , this should help 7 steps to a beautiful and useful agile dashboard

Here are some filters which might help,

- Issues completed in specific sprint
project = projectname AND status in (Resolved, Closed) AND Sprint = sprintno

- Issues missing storypoints
project = projectname AND resolution = Unresolved AND Sprint in openSprints() AND "Story Points" is EMPTY AND type in (Story)

- Active Sprint In Progress Longer than 6 Days 
project = projectname AND resolution = Unresolved AND Sprint in openSprints() AND status = "In Progress" AND status changed to "In Progress" before -6d AND issuetype not in (Epic) ORDER BY updatedDate ASC

- Issues in progress and missing due dates
project = projectname AND resolution = Unresolved AND Sprint in openSprints() AND duedate is EMPTY AND Status not in (Open)

- Total number of scheduled issues (based on assignee - pie chart)
project = projectname AND resolution = Unresolved AND Sprint in openSprints()

- Upcoming or missing duedate
project = projectname AND resolution = Unresolved AND Sprint in openSprints() AND duedate <= 5d

-Future sprint unassigned
project = projectname AND resolution = Unresolved AND Sprint in futureSprints() AND assignee is EMPTY

- All issues open sprint
project = projectname AND Sprint in openSprints()

You can make the adjustments as you like depending upon your requirements, also go see to understand Advanced searching in jira Cloud 

[Sha Melo]

Awesome. Thanks!

[Sachin]

Your welcome!