How to Create a Precise and Concise Jira Dashboard for Tracking Ticket Statuses?

[Santosh Narayanan]

Hi everyone,

I am looking to build a dashboard in Jira using the available templates.

My goal is to create a clear and concise dashboard that can be projected on a live screen for my team. I need to track the following metrics:

1. Number of open tickets for the day

2. Number of tickets resolved

3. Number of tickets moved to WIP

4. Number of tickets moved to On Hold

5. Number of tickets canceled

So far, I have created a few dashboards using the available information, but I want to refine them to be more precise and user-friendly. Could anyone guide me on how to achieve this?

Specifically, I would appreciate advice on:

*Choosing the right gadgets and widgets for these metrics

*Configuring filters and JQL queries to accurately capture the data

*Tips for layout and design to make the dashboard easily readable at a glance.

Any best practices or experiences you can share for building effective Jira dashboards

Thank you in advance for your help!

[Danut M _StonikByte_ · Accepted solution]

Hi @Santosh Narayanan,

Jira offers some useful gadgets, like Issue Statistics gadget,  Two Dimensional Filter gadget or Pie Chart. These are good to display metrics in term of number of issues from a filter.

Complementary to these gadgets are Issue Filter Formula gadget, Advanced Issue Filter Formula or Pivot Table & Pivot Chart gadget offered by our Great Gadgets app. With these gadgets you can create multi-dimensional statistics, calculate and display percentages, sum-up a field,  or calculate advanced metrics by combining the issues from multiple-filters.

See some examples:

Advanced Issue Filter Formula gadget

Pivot Table & Pivot Chart gadget showing a 3 dimensional statistic (by Assignee, Project and Issue Type) as a heat-map

Issue Filter Formula gadget showing a value in a "gauge" chart

All these gadgets support wall-board mode and dark theme, so you can project them on monitors in the team's open space. 

The app offers many other gadgets that let's you visualize charts with trends, not just actual numbers. 

Have a look over these articles to make a better idea about these gadgets:  

• https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369
• https://community.atlassian.com/t5/App-Central/8-gadgets-for-a-powerful-Scrum-dashboard-in-Jira/ba-p/1683063
• https://community.atlassian.com/t5/Jira-articles/Building-a-powerful-Kanban-dashboard-in-Jira-with-Great-Gadgets/ba-p/1664331

You could try with a 1-month free trial. If you need any help, feel free to contact support@stonikbyte.com.

Hope this helps.

Danut.

[Nicolas Grossi · Accepted solution]

@Santosh Narayanan Welcome! you might want to use the Two dimensional filter gadget on a given filter.

Nicolas