I wan to make a JIRA Dashboard to see all sub tasks for Epic and for all the epic worked on past 6m

[Kiran Khan]

For each epic we have User stories and we log bugs as sub tasks with each US 

I want to make JIRA Dashboard which shows all bugs ( sub tasks of User stories ) for each epic we worked on last 6 months 

[Amay Purohit_RVS]

Hi @Douglas Martins 

Welcome to the community !!

As suggest by Jack, a third party app can help you with this use case. If you would be interested in the same, do take a look at 

Issue Hierarchy

Not exactly a pie chart but the app can help you with a bar graph for issue types under the Epic as shown in the video below.  This can be added as a dashboard gadget too.

The app also shows your issue hierarchy in a tree view and help you easily Sum up values (time tracking/story point/custom numeric fields) to see overall progress for your Issues at each parent level. Also it provides excel like editing for all the values right on the report and see real time progress updates. 

Do give it a spin.

(Disclaimer: I work on RVS, the vendor for this app)

[Douglas Martins]

I want present on my dashboard the total issues including sub-tasks under each EPIC.

As you can see below, there are 177 sub-taks (None) that aren't allocated to their respective EPIC.

Based on my JQL I know for example that out of 177 sub-tasks(None), 116 subtasks are related to the 1st EPIC - Create(blue).  

[Jack Brickey]

So that I might replicate please share your JQL and the configuration of the pie gadget.

[Douglas Martins]

project = XXX AND cf[10800] = 17000 and type in (task, story, "sub-task") and "Parent Epic" in (a, b, c, d, e, f) AND Sprint in (112265, 112530, 112891, 113496, 113522) ORDER BY status DESC, Rank ASC

Configuration pie gadget:

Filter: "JQL above"

Statistic Type: EPIC

Thanks Jack. 

[Jack Brickey]

Hi @Douglas Martins , I believe what you are seeing is that by using "epic" for the statistic you are seeing None because, subtasks do not have the Epic as the parent.

Also, you indicate "epic" as the stat but the image shows "epic link" which coincidentally has been replaced by "parent".

[Douglas Martins]

Correct, Jack. However, as mentioned before, this is my problem. How can I represent all Jira tickets under each EPIC (Graphically- Jira dashboard/using gadgets), including the sub-tasks (which is my current issue to be solved)?

Do you have any ideas? Or, because subtasks only inherit an EPIC but aren't directly linked to the EPIC, I won't be able to show them through Jira dashboard(gadgets) at all?

Thanks again.

[Jack Brickey]

hi @Douglas Martins ,

Native JQL will not perform nested search. I can offer two options off of the top of my head:

• leverage a third-party addon from the Marketplace, e.g. Scriptrunner 
• use a custom field or label to capture the epic on any subtask. Leverage automation to update the field/label when a subtask is added to a story associated with an epic by using the "parent" field from the Story. This will consume automation so be sure the set up conditions to only execute the action when needed.

You may find other options to consider within the community. The inability to include subtasks associated with Epics using JQL is an old and very hot topic. As such there are quite a few posts in the community on this topic. You likely will find a post that gives you an exact automation solution. You'll most certainly find solutions using scriptrunner or similar add-ons. However, if you decide to go to the automation path and get stuck, trying to create such automation, please do let me know and I can try to find some time to provide one.

[Jack Brickey]

Hi @Kiran Khan , before turning to the actual dashboard part of your question let's try creating the JQL and asses the results to see if it contains what you want. Try the following as a starter but tweak to meet your actual needs.

project = abc and type = subtask and parentepic in (x,y,z)

In the above you'll define your project and you will also need to define the specific Epics. There isn't the ability to use "parentepic is not empty" unfortunately. As well, you will know that I have not put any timeframe in the above JQL example. This is because I need to understand what you mean by "worked on". It may be that we can use the "updated" operator but unsure until I understand your use case better.

[Kiran Khan]

@Jack Brickey  Worked on means we just need to have those epics in which "sub-task" is added in last 6 months in order to not get very old and obsolete data + in order to get the results which needs focus 

1- we have epic in which we have User stories -> we Log bugs as sub tasks with User story 

2- we need a dashboard which shows bugs per each epic only for those epics in which we added any in last 6 months 

[Jack Brickey]

so maybe this....

project = abc and type = subtask and parentepic in (x,y,z) and createdDate <= startOfDay(-6M)

Does that return the desired/expected bugs?

[Douglas Martins]

Hi @Jack Brickey I am trying to do the same thing, but I don't have any issues with the JQL. It is working fine, and I have the information that I need. The issue is displaying the info on my dashboard (pie chart and two dimensional) as the sub-tasks appear as "NONE".

See example below (dashboard: dimensional / same apply for pie chart)

Epic Link(Name)

  - None:    100       (80 sub-tasks related to EPIC AAA AND 20 related to EPIC BBB)

  - AAA:      50         (It should be 130  = 50 (tasks/stories) +80 sub-tasks)

  - BBB:       20         (It should be 40 : 20 (tasks/stories +20 sub-tasks )

Thanks for your support. :) 

[Jack Brickey]

Hi @Douglas Martins , I am not following here. Please provide more details of your used case. What is your end goal? Share your JQL and results? Share image of dashboard results.