I have multiple teams and they feed their data in their team page's table. I wish to have a summary table in which I can fetch required data from multiple other tables. The way you do it in excel by putting an "=" in the cell and giving reference to the other cell.
Is this possible in Confluence?
Yes. You need a few bucks to buy CustomWare Scaffolding and CustomWare Reporting.
Thanks for the answer Stefan!
Is there no other option than buying the plugin? My requirement is just getting data from different tables into one. The tool offers many other functionalities that I will never really use.
Are there any default macors that I can use?
Thanks again for the help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nishant,
You can do it with the help of Table Filter and Charts for Confluence.
The Table Excerpt (Include), Table Transformer macros are appropriate for your use case.
Here's an example of how to use them:
First, you need to wrap all required teams' tables with the Table Excerpt macro.
Then add the Table Excerpt Include macro on a separate page with a summary table and configure it.
Now wrap this Table Excerpt Include macro with Table Transformer and enter the following SQL query:
SELECT 'Project ID:','Project Status:' FROM T*
Finally, you need to wrap it all with one more Table Transformer and choose the 'Lookup tables' preset.
Result:
Please use our documentation to get more info about our app.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nishant,
You can do it with the help of Table Filter and Charts for Confluence.
The Table Excerpt (Include), Table Transformer macros are appropriate for your use case.
Here's an example on how to use them:
First, you need to wrap all required teams' tables with the Table Excerpt macro.
Then add the Table Excerpt Include macro on a separate page with a summary table and configure it.
Now wrap this Table Excerpt Include macro with Table Transformer and enter the following SQL query:
SELECT 'Project ID:','Project Status:' FROM T*
Finally, you need to wrap it all with one more Table Transformer and choose the 'Lookup tables' preset.
Result:
Please use our documentation to get more info about our app.
Katerina
StiltSoft
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nishant,
You can do it with the help of Table Filter and Charts for Confluence.
The Table Excerpt (Include), Table Transformer macros are appropriate for your use case.
Here's an example on how to use them:
First, you need to wrap all required teams' tables with the Table Excerpt macro.
Then add the Table Excerpt Include macro on a separate page with a summary table and configure it.
Now wrap this Table Excerpt Include macro with Table Transformer and enter the following SQL query:
SELECT 'Project ID:','Project Status:' FROM T*
Finally, you need to wrap it all with one more Table Transformer and choose the 'Lookup tables' preset.
Result:
Please use our documentation to get more info about our app.
Katerina
StiltSoft
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, Nishant!
For any calculations in Confluence, including referencing table data, you may use CelesteCS Math for Confluence. For referencing the cell on the table on another page, specify the page name in macro parameters and reference table cell like here:
Table1.A1
There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.