How to add progress% for two different multiexcerpt macro under one table transformer?

prescy kulshrestha

To get Delivered Records,  this table transformer SQL query is fetching only for one multiexcerpt, but can I should include also the other one :

SELECT FORMATWIKI ( "{cell:align=right}" + SUM('No. of delivered records') + "{cell}") AS 'Delivered Records', "FACE_DETECTION_IMAGES" AS 'Project', SUM('No. of delivered records') AS 'Delivered Records' FROM T* WHERE 'Status' = "DELIVERED" GROUP BY 'Delivered Records', 'Status', 'Project'

 

In there a fix for this?

 

 

Stiltsoft support

Hi @prescy kulshrestha ,

The Table Transformer macro is provided by our app - Table Filter, Charts & Spreadsheets for Confluence. The Multiexcerpt macro is not ours.

So, if the issue is that you need to collect two (or more) tables with similar headers from other pages, combine them into one big table and perform calculations using this combined report, you may use the Table Excerpt/Table Excerpt Include macros.

In the settings of the Table Excerpt Include macro you may tick the "Show as a report" option, and your tables will be automatically merged into one big table.

Then you wrap the Table Excerpt Include macro in the Table Transformer macro and continue to work with the combined report.