How can I list JIRA issues in a table but change it to say something different than "X issues"?

Question

I'd like to make a table in Confluence that lists quantities of JIRA issues in a project, but I would like to have it say something other than "3 issues" for example (like "3 studies" or "3 tests").

Am new to JIRA and Confluence and am just starting to learn JQL. Any help would be much appreciated!

Katerina Kovriga {Stiltsoft} · Answer

Hi there,

As this Community question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view&edit mode. The Table Spreadsheet macro is available for Cloud and Server/Data Center.

Katerina Kovriga {Stiltsoft} · Answer

Yes, you are right - the Table Transformer macro is based on the AlaSQL library.

Matt Harlow_5c6ekw · Answer

Thank you! Is that syntax all SQL? Yet again, beginner here. Just trying to dissect and understand it. May warrant diving further if it is SQL.