Can't find a way to aggregate and compile data

Julien Senecal

Hello all,

I'm trying to get data from multiple tables to expose a summary.

I'm having multiple tables with a status column that can have 5 value (blocker, waiting for, approved, ready for approval, image needed) and I want to see how many of each status I got in overall.

I can't figure out the proper SQL needed as I have limited knowlegde on that matter.

Here's a sample how one data table

Anyone would know how to retrieve this data from multiple table and compile them?

Thanks!

Katerina Kovriga {Stiltsoft}

Hi @Julien Senecal ,

Please follow my example.

Step 1 will be to wrap every mini table with statuses into the Table Excerpt macro and assign it any name you want (it will be Test for my example):

Step 2 will be to nest our macros inside each other directly for Server/DC or with the help of the Table Toolbox for Cloud:

Step 3 is to collect all your tables with the help of the Table Excerpt Include macro:

Step 4 is to merge your mini tables into the one big result table with the help of the Table Transformer macro (choose the standard Merge preset):

Step 5 is to count your statuses with the help of the Pivot Table macro:

And as an optional step 6 you can visualize your pivot with the help of the Chart from Table macro:

Hope this helps your case.