Pie Chart of Table using Math. Formulas

[hkt]

Hello,

I would like to ask for an advice, how to realize followings:

As a part of Confluence page, I want to create a table containing values describing status of  list of test cases. Each case has status PASSED/FAILED/etc. ... I want to create additional column or table with overall count of PASSED, count of FAILED, ... and display it in a pie chart.

Something like this:

I tried to use Chart Macro, it creates the chart on picture. But problem is with the table. Standard table in Confluence can not use formulas, so the table on picture is manually filled. I tried to insert excel file with the table, but it seems to be not compatible with usage within the Chart macro.

Please, any idea how to solve such a task?

Thanks in advance for any help.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @hkt,
 
You’ll need additional apps from the Atlassian Marketplace to use formulas and support dynamic tables to create charts.

I can suggest trying the Table Filter and Charts for Confluence that is our add-on.
You’ll be able to use formulas using the Table Transformer and Table Spreadsheet macros, the result tables are fully supported by the Chart from Table macro.

If you are not familiar with the app, we’ll be happy to organize a live demo for you and your team. Please book a suitable timeslot here.