Macro for Jira Count

[UdayKiran]

want to get the issue COUNT only into Excel using JIRA.JQL.

Any pointers/suggestions?

I see an option to get  in the JIRA macro on Confluence to get the issue count. Any pointers on how it is doing?

currently JIRA.JQL is returning the results in multiple rows but i'm need of only the count.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @udaykiran,

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

Its Pivot Table macro supports dynamic tabular Confluence macros. So, you may wrap your Jira Issues macro in the Pivot Table macro and count all the issues or create aggregated (pivot) tables like in Excel (count issues by statuses, assignees, etc.).

Hope it helps your case.

[Danut M _StonikByte_]

Hi @UdayKiran,

Try our Great Gadgets add-on. It offers many macros that you can use in Confluence.

With Issue Filter Formula Gadget you can calculate and display the COUNT, as well as MIN, MAX or AVERAGE for the issues in a filter.

With Advanced Issue Filter Formula Gadget, besides these simple formulas, you can display up to 6 complex formulas (like percentages), based on up to 6 filters. 

If you have questions, please let contact us at support@stonikbyte.com.

Thank you,

Danut M. 

[Ojase Emmanuval]

Hi @UdayKiran Please use Display option--> Total count setting in JIRA macro to show the issue count

Thanks,

Ojase

[UdayKiran]

Thank you, Ojase.

I did see this option. Wanted to know macro/JQL query to understand how this query is working.