Need syntax for JQL to provide a whole number count of issues as a return from a query

Question

I am working to create a Dashboard in Confluence which use the default "Chart" macro. This macro requires a table with data in each cell:

However, to do this dynamically so that the chart is always up to date when someone lands on the confluence page, I need to query Jira for and return an number (of issues) that match my Jira query that the Chart Macro widget can use to create the chart dynamically.

I have tried to use the Jira Issue Filter Macro but that return the number with "issues" after it which the Chart Macro can't use.

Can this be done?

Chris Streeter_ljn2h3 · Answer

Unfortunately, I work for a very larger corporation and I don't have the option of doing those add-ons myself.

Chris Streeter_ljn2h3 · Answer

Kind of figured that but thought it was worth a try.

Katerina Kovriga {Stiltsoft} · Answer

Hi @Chris Streeter ,

We can suggest our app - Table Filter and Charts for Confluence - to create Jira dashboards in Confluence based on the standard Jira Issues macro. Our Table Filter, Pivot Table and Chart from Table macros work with dynamic Confluence macros perfectly well and allow you to visualize your data.

Here are several examples of such dashboards and here is a link to book a live demo from our team - we'll be happy to show you even more use cases.