I want to create a dashboard

[J S S S Bharath]

I want to create a dashboard which shows the jiras linked or related to one or more jira epic(s)

1. show the report vs resolved statistics
2. Show the report per category of the jira viz. enhancement, bug, task, sub-task

[Danut M _StonikByte_ · Accepted solution]

Hi @J S S S Bharath,

Unfortunately, Jira’s native gadgets are quite limited when it comes to displaying issues by hierarchy or showing linked issues. At best, you can use the Filter Results gadget with a JQL query that returns the issues within your epics, allowing you to display a simple list of those items (without sub-tasks!) on your dashboard.

Also, you can try the Two Dimensional Filter Statistics gadget to get the number of tasks (again, no sub-tasks) per epic and status.

For something better, you will need a plugin (app) from Atlassian Marketplace. If you are open to trying a plugin, our Great Gadgets app offers some really useful gadgets for this.

Work Breakdown Structure (WBS) gadget - can display the issues from a filter/JQL issues by their hierarchy Epic > Story > Sub-tasks along with their status.

Or, it can display the issues along with their linked issues and their status. In this case you have to configure it with a filter/JQL that returns only the epics. See also https://community.atlassian.com/forums/App-Central-articles/How-to-Visualize-Linked-Issues-and-Their-Status-in-Jira/ba-p/3150240 

 

Pivot Table & Pivot Chart gadget - Allows displaying multi-dimensional statistics in form of tables, heatmap tables or charts of various types. It can display count of issues in each epic, sum of story points, percentage of completion. It can include the sub-tasks. Here is just an example:

To get this, the gadget should be configured like this:

See also https://community.atlassian.com/forums/App-Central-articles/How-to-display-the-progress-of-Epics-or-Initiatives-in-Jira-or/ba-p/2858840

Hope this helps.

Danut. 

[Trudy Claspill · Accepted solution]

Hello @J S S S Bharath 

You will need to start by creating a Jira filter that retrieves the issues you want.

If you Jira Epics are
ABC-100, ABC-200, ABC-300
then you can get all the issue that are linked to them through generic issue linking using this query:

issue in linkedIssues("ABC-100") or issue in linkedIssues("ABC-200") or issue in linkedIssues("ABC-300")

If you want to get all the child issues of those Epics you can using this query:

"Epic Link" in (ABC-100, ABC-200, ABC-300)

Reference: Advanced Searching Functions and Advanced Searching Fields

You then need to find gadgets that display the data as you want.

For #1 there is the Created vs. Resolved Chart

For #2 if you are looking for the reported vs. resolved data per category then you would need to create additional filters that include criteria to get the issues just per a specified category. You could then add to your dashboard additional instances of the Created vs. Resolved Chart with each one referencing the filter that selects issues for a different category.

Reference: Configuring Dashboards

[Jack Brickey · Accepted solution]

Hi @J S S S Bharath , is your goal to actually show "linked" work items or children of an epic (or maybe both)?

If you want the children then create a filter like...

parent = abc-9

if you want to only show issues linked to an epic excluding children of the epic...

issueLink = abc-9 and "epic link" != abc-9

if you want to show both linked issues and children...

issueLink = cjt-9

Once you have created your filter(s) to get the desired results then you can use various gadgets in your dashboard, e.g. two-dimensional to display the issues by status.

[Rahul_RVS]

Hi @J S S S Bharath 

If you are open to try out a mktplace app for a complete solution to manage your projects and track your tasks, take a look at our app:

Agile Tools

Below are the main features of the app:

1) Links/Portfolio/Advanced Roadmaps Hierarchy :- View/Manage roll up for hierarchy (up to 10 levels), based on your Portfolio/Advanced Roadmaps/Issue Links parent child relationship.

2) Epic Hierarchy :- View/Manage roll up for standard Jira hierarchy. Epic -> User Story -> Subtask

3) Time in Status :- More than 7 types of Time in Status reports to track issues.

4) Worklogs Report :- Track time spent by resources with multiple filters / category / grouping features

5) Timesheet :- View/Enter your time spent for multiple days

Disclaimer : I am one of the app team member

[Laura Marin]

@J S S S Bharath while you can certainly fulfill your first need with Jira native solutions by creating a specific JQL for each set of epics and then a separate dashboard for each JQL you just created, this is simple when epics are created or evolve slowly, but when epics are fast then it will takes a lot of effort to maintain these "hardcoded" dashboards. 

If you're open for a third party solution, I can suggest you give it a try to Millarum Dashboards, where you create the dashboards once and then the filter gets updated on the fly through the Slicer widget, this way you can focus your view with sight changes. Then there are also multidimensional charts so you can see details per one field when stacked on bars representing other field, and even the Sankey diagram allows for 6 dimensional representation.

[Eduardo Anflor - MindPro]

Hi, @J S S S Bharath 

I am not sure you can meet exactly these requirements with Jira's out-of-the-box functionalities. If you are open to a marketplace solution, I recommend Mindpro Insights. I work at Mindpro, and I believe the app can help with this scenario.

It allows anyone to create and share dashboards with dynamic gadgets easily. It means when you click on a chart segment, the entire dashboard adapts to the filter. You can choose from over 50+ available.

The app also has a "Hierarchy" filter that displays the sub-items in an indented way, and the gadgets will respect the hierarchy selected:

You can choose one or more items in the hierarchy filter.

I hope that helps.

Regards,

Eduardo