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

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.

3 answers

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.

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

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.

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

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.

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".

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,051 views 16 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you