Display Table filters on Merged Tables

Monica Lavin
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 21, 2023

I'm new to macros, so I'm looking for guidance on how to best combine macros to get my desired result. 

 

In my space, I have a several pages that include multiple tables each, all tables have the same column headers and Table Filters added to them. 

 

On a different page in the same space, I'd like to 'merge' all of the tables into 1, keeping the Table Filters. Then, I'm adding a Gantt chart to the 'merged' table. 

 

I've attempted to use a series of Excerpt Table, Excerpt Table Include, Table Transformer macros, but everything I try results in the 'merged' table NOT showing the filter options, but all the individual tables show below, with the filters. 

1 answer

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 22, 2023

Hi @Monica Lavin ,

I suggest referring to our support where you'll be able to share your screenshots confidentially and we will guide you through the case.

As far as I see from you description, if you have multiple tables with the same headers, you may wrap them into the Table Excerpt macros. Seems that it is what you do now.

Then on your master page you collect them via the Table Excerpt Include macro. Here in the macro settings you tick the "Show as a report" option and all your tables are merged into one big table automatically. You don't need the Table Transformer macro to merge your tables in this case.

Then you wrap your Table Excerpt Include macro in the Table Filter macro and set the required filters.

The last step will be to wrap your Table Filter macro in the Chart from table macro.

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 22, 2023

Hi @Janice ,

Please add some tags for us:

  • table-filter
  • table-filter-and-charts

Thanks!

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events