Can I link the confluence chart macro with an external table?

[James Mark Chan]

We are using a confluence page with a table to record test data. We want a chart to update based on this test data. Is this possible? We still want the table to be visible on the chart because it has a column for columns.

[Milo Test]

I don't think that is possible. Take a look at Confiforms; it allows you to generate a chart based on data that is edited elsewhere.

[Alex Medved _ConfiForms_]

James Mark Chan +1 to Milo's answer.

We are the authors of ConfiForms and will be happy to help you with what you want to build. It is totally possible with ConfiForms

[Darrel Lee]

He is wrong.   Trying to sell his product?

You can use a CVS table macro inside the chart macro.   Set the output format to wiki.   The preview in the chart macro doesn't seem to work, but the chart renders on the page just fine.   I am using Confluence 5.7.

[Alex Medved _ConfiForms_]

It depends on how often your CSV shall be updated. What Milo suggests is to keep and update the data with ConfiForms directly inside Confluence.

And build your charts on the data you have - using standard Atlassian Chart macro or more advanced Table Filter and Charts mentioned by @Andrey Khaneev _StiltSoft_

We specialise in this area  - presenting the data from different sources, including external sources / systems

And have another option here to share. Yes, it is a plugin, we develop, it is called ConfiDoc and the example of CSV showed on a page as a table and as a chart could be found here.

Promoting someones product is not a bad thing, if it helps to solve the problem (and when the problem cannot be solved with Confluence standard options).

BTW, @Darrel Lee, you shall consider upgrading your Confluence version, as it has reached EOL

[Bob Swift OSS (Bob Swift Atlassian Apps)]

You can include a table from various sources in the body of the built-in chart macro.

• a standard Confluence table (sounds like this is what you have)
• a separate page with the data together with an include page macro
• SQL data using the SQL-query Macro
• Excel data using the view file or Excel Macro
• CSV data using the CSV Macro
• HTML table using one of the html macros
• a bunch of other macros

 Use the Display rendered data to display the data before or after the chart. Or if that is not sufficient, just put the data on a separate page and include it once in the chart macro and once by itself.

[Amit Ahuja]

Can you please share an example ? I am trying to follow above but getting an error like:

Error rendering macro 'chart' : org.dom4j.DocumentException: Error on line 1 of document : Open quote is expected for attribute "id" associated with an element type "div". Nested exception: Open quote is expected for attribute "id" associated with an element type "div".

[Mukund Iyer Rajamony]

+1 
A simple example of the chart macro with data from outside would be most helpful.
We would like to use the confluuence chart to update based on nightly test results for example.

[Andrey Khaneev _StiltSoft_]

Try Table Filter and Charts add-on, maybe it is what you are looking for.