How do I remove duplicate sub tasks from a query?

Question

Hi,

I've been looking and experimenting for hours and can't find a solution.

In a project I have setup for a team we have the following setup

Initiative

Epic

Story

Sub-task (Summary is product A)

Sub-task (Summary is product B)

Sub-Task (Summary is product C)

Story

Epic

Story

Sub-task (Summary is product A)

Sub-task (Summary is product B)

Sub-Task (Summary is product D)

Sub-task (Summary is product E)

Sub-task (Summary is product F)

Sub-Task (Summary is product G)

Story

This layout continues into 56 different Epics totally 622 sub tasks across the project.

This is fully intentional, as a requirement from the team. It has additional things like labels and components so I could show the relationship of the "product" across different Epics.

So what I'm trying to do now is replicate the reporting that they were doing in Excel (requirement was to move the team away from using Excel and into JIRA), part of this is to show how many UNIQUE sub-tasks there out of the 622 on a dashboard.

The creation of a dashboard isn't the problem, it's the JQL query  to do something like "exclude duplicate summary" as the summary will be exactly the same.

It's worth noting I am on :-

JIRA Service Management Application v10.3.8

I work for a large company, don't have Admin access nor can I download/install any plugins.

Hopefully somebody can give some guidance on what seems simple but I'm rapidly losing my hair on it :-)

Thank you in advance.

Marc -Devoteam- · Answer

Hi @Mark Bedford

I understand, and for what you require, no there is no such option in JQL.

Not even with apps that extend JQL capabilities within Jira, as it finds issues based on the given query.

So your question then gets BI related, so you could use eazyBI, or you could see to get the information outside Jira in a BI tool, but based on your response this is not what management wants.

See this for eazyBI, https://community.eazybi.com/t/remove-duplicate-summary/12134

Karim Buzdar · Answer

eazyBI is a powerhouse for exactly this kind of complex reporting. It's ability to pull and transform that data should save you a lot of time.

Good luck!

Mark Bedford_4yfz0c · Answer

Hi Karim,

I'm already using the Two-Dimension filter for another view, I will adjust things and see if I can get it to show the unique count.

Sadly any add-in's are blocked. It's a restricted/sensitive company.

I think this morning I've come to the conclusion I will try EazyBi for this, hopefully that will do it.

Thanks for comments.