Create a chart from a table on a child page

Question

Hi All,

I have a very specific request. I have a project which is starting. I have created a Project landing page. Under that there are some child projects which has some tables to track the inventory. Each of this inventory has status. Say there are 50 integration points, I will have 50 entries in table with status like Design, Build, Testing, Completed. How in the landing page I would need a chart(PIE) which shows what is the integrations status. how many in build status and other statuses. Thanks in advance.

Regards,

Ajay

Stiltsoft support · Answer

Hi @Ajay Menon ,

The Table Filter and Charts for Confluence app kindly mentioned by @Marc -Devoteam- is developed by our company.

Indeed it may help you with the case:

* place multiple-row tables with statuses on your child pages
* wrap each table in the Table Excerpt macro
* collect all your tables into one big report on your master page with the help of the Table Excerpt Include macro
* wrap your Table Excerpt Include macro in the Chart from Table macro and build the result chart

If the statuses are updated in your source tables, all the changes will be automatically pushed through the Table Excerpt/Table Excerpt Include macros and your chart will be updated as well.

As you've mentioned the spreadsheet macro, please clarify what exactly you are trying to use.

The Table Filter and Charts for Confluence app also provides the Table Spreadsheet macro which parts can be easily reused with the help of the Table Spreadsheet Include macro and they are compatible with other our macros - are you talking about these macros or smth else?

Marc -Devoteam- · Answer

Hi @Ajay Menon

Can you show a screen shot of the spreadsheet macro you have.

Which app provides this option in your Confluence instance?

Ajay Menon_nl1hh1 · Answer

Thanks so much for the response @Marc -Devoteam- . Is there any other way. Like using spreadhseet macro. Use excerpt and inside that chart which can generated from data from spreadsheet. Use Excerpt include in main page and just show the chart. :(

Anything willl help.

Thanks in advance,

Ajay Menon