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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.