What widget can I use, to display total count of items by fix version

[deneice_bhola]

would like to show the epic name and count of items, in a table, as a widget, on my confluence page

[Martin Runge]

Hi @deneice_bhola

Welcome to the Atlassian Community!

You can use a Two-Dimensional Filter Statistics macro from Jira. It is the best way to achieve this on a Confluence page. It allows you to cross-reference data and display a total count of items in a table format.

To set this up:

1. Create a Filter in Jira: Save a filter that captures the Epics and items you want to count (e.g., project = "Your Project" AND issuetype in (Epic, Story, Task)).
2. Add the Macro in Confluence: Type /jira on your Confluence page and select Jira Two-Dimensional Filter Statistics.
3. Configure the Axes:
   • X-Axis: Select Fix Version.
   • Y-Axis: Select Epic Link (or "Parent" depending on your Jira configuration) to show the Epic names.
4. Save: The macro will generate a table showing the count of items for each Epic, broken down by Fix Version, with totals at the end of each row and column.

[Tomislav Tobijas]

Hey @deneice_bhola ,

Apart from using what Martin described, you can also simply embed Jira work items (as a list) on a Confluence page by using Jira work items macro. 

You can configure that view to display whichever data from actual work items you like, and at the bottom right corner of the macro, you'll see the total number of work items by defined search of JQL.

It kinda depends on how you'd like to display or visualize things from Jira, like what's the end goal here.

Cheers,
Tobi

[Danut M _StonikByte_]

Hi @deneice_bhola,

The solution suggested by @Martin Runge, based on the Two Dimensional Filter Statistics macro, is definitely the first option to try, as it relies on native Confluence features.

If you also have the Great Gadgets app installed in your Confluence instance, you can achieve this using the Pivot Table & Pivot Chart macro.

This macro can display data as a table, heat map, or various types of charts. In addition, it allows you to split data by multiple fields and calculate metrics such as the sum of story points within each epic. In addition, it supports also JQL as data input. 

To display such a view, the macro must be configured like this:

 

Danut.