Make Count of Issues With Conditions Easier

[Nate Dickinson]

Does the confluence Jira macro have the ability to count filtered data by a JQL query more easily than I have been doing? 

Here's my use case: 

I have identified issues that need to be remediated. They are classified by sub business type and have a severity rating. There can be many issues associated to a sub business type at varying levels of severity depending on the issue. 

So I'm trying to put a table together that looks something like this where I have the name of the sub on the left and the counts for each issue severity on the right. I've been able to make this table by creating a JQL query for each count. This works ok when there are only a few subs, but I have about thirty subs, which is making for a lot of manual work. (30 subs * 4 severity statuses= 120 unique JQL queries) 

Is there some better way to do this? 

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Nate Dickinson,

We can suggest trying our Table Filter and Charts for Confluence app.

Our macros support the dynamic Jira Issues macro. So, you will be able to display your issues, their types, and priorities on Confluence page via the Jira Issues macro (in a tabular view, each issue for each row). Then you may wrap this macro in the Pivot Table macro and aggregate your issues by types and priorities (like you create pivot tables in Excel).

Hope it may help your case.

[Nate Dickinson]

Hi Katerina. We have this plugin and received a reply from a Jira Service Management ticket from Nikita. THanks.