Can I create two charts from the same table?

[Andrew Donaldson]

I am trying to create two different charts based off the same table. Short of recreating the table, is there another way of creating the second chart?

[Bob Swift OSS (Bob Swift Atlassian Apps) · Accepted solution]

Put the table on a separate page. Then use include page macro inside the various chart macros.

Here is the storage view of the page:

<ac:structured-macro ac:name="chart"><ac:parameter ac:name="dataOrientation">vertical</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="include"><ac:parameter ac:name=""><ac:link><ri:page ri:content-title="chart include" /></ac:link></ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro>

[Andrew Donaldson]

i tried that and it didn't work, any other suggestions?

[Bob Swift OSS (Bob Swift Atlassian Apps)]

It does work. Double check your pages.

[Andrew Donaldson]

It does work, Out of how is this different from copying and pasting the table twice?

[Bob Swift OSS (Bob Swift Atlassian Apps)]

It makes it possible to only have one copy of the table so that when it gets updated, both charts will reflect the same update.

[Sandeep_Sharma]

This worked for me as well but did not solve the purpose. It allows only 1 chart from a table. This is what I intend to achieve

1. Create single table on "Page 1" 

2. Create 3 different charts on "Page 2" using the same table on "Page 1"

3. I am able to create 1st chart by including "Page 1" but as soon as I try 2nd chart, the 1st page include vanishes. Looks like it allows one page to be included only once.

Is there a way I can include a section (table in this case) from Page 1 multiple times on Page 2 for creating different charts?

Please suggest.

[Katerina Kovriga _Stiltsoft_]

Hi @Sandeep_Sharma ,

We can suggest using our app - Table Filter and Charts for Confluence. It's available for Cloud/Server/Data Center.

This case is a common one for the app: you reuse your source table as many times as you need with the help of the Table Excerpt/Table Excerpt Include macros (on the same page or other pages).

Then you wrap each Table Excerpt Include macro in the Chart from Table macro and create different charts based on the same table. So, you'll get a kind of a dashboard.

[Sandeep_Sharma]

Thanks Katerina!

I am yet to try this in full but read through the documentation and it should help me fulfill my requirement.