How to refer to the data on chart table on another confluence page

[Will Wang]

I want to auto populate the first row of column "Percentage" on confluence page A with the value(task completion percentage 97.4%) on the chart table on confluence page B, how can this be achieved ? If not, any workaround, e.g. calculate the percentage in the table on page B and refer it on page A?  Can the field on one confluence page refer to another field/value on another confluence page ?

Page A

URL: https://confluence.example.com/A

Table on page A

Date	Name	Percentage

Page B

URL: https://confluence.example.com/B

Below is the chart created from table on page B

[Aleksandr Zuevich · Accepted solution]

Hi Will,

Yes, the field on one confluence page can refer to another field/value on another confluence page. You can do it with help of Excerpt and Excerpt Include standard Confluence macros. 

[Will Wang]

Thanks, Aleksandr, can Excerpt and Excerpt Include achieve dynamic update ?

Namely when the field on page A changes, the file on page B will also changes automatically when I refresh page B ? Any example ?

[Aleksandr Zuevich]

Will,

If you update table cell on the source page the excerpt include macro will show new value on the destination page. But it is not dynamic content, it's static. Otherwise if you need to include dynamically calculated content you can find and use some plugin like https://marketplace.atlassian.com/apps/1212655/celestecs-math-for-confluence. It is allowed to refer table values on another page.

[Will Wang]

Hi Aleksandr,

     Thanks, I did a simple testing(change value from a to b in the excerpt macro on source page and then refresh the destination page, the value changes), the solution works. 

     But got another issue that could not embed the value on the chart into excerpt macro, any way to achieve this ? 

[Aleksandr Zuevich]

Hi Will,

If you put Chart macro inside Excerpt macro you can refer to the whole chart on the destination page.

[Will Wang]

  Alternatively, if could embed the value on pivot table into excerpt macro is also fine as I can insert one pivot table into the page as workaround.

[Will Wang]

Hi Aleksandr,

    Any sample for below or knowledge link  ? I tried but only can input some text info on the excerpt macro, not sure how to put chart macro into excerpt macro.  in fact, only want to put completion percentage(currently it is 97.8%, but may changes when more tasks is finished) into excerpt marco 

If you put Chart macro inside Excerpt macro you can refer to the whole chart on the destination page.

[Aleksandr Zuevich]

Will, take a look into the next picture. I just place Chart macro inside Excerpt:

[Will Wang]

Hi Aleksandr,

    I used the chart from table&pivot table which was generated based on one table on the same page, have tried, can embed chart into excerpt but can't embed "chart from table" into excerpt.  Below is the pivot table generated, any way to embed value(97.8%) of developer displayed on"chart from table" or "pivot table" into excerpt ?

[Aleksandr Zuevich]

Will,

Could you please show us your "table&pivot" table? It seems that it's not standard macro but you're using some plugin for that. 

[Andrey Khaneev _StiltSoft_]

Looks like this is Table Filter and Charts app.

[Will Wang]

Hi Aleksandr,

   Kindly refer to first capture for pivot table&chart from table button on confluence page, refer to second capture for the source data(sample data only, but is very similar to our actual data) and related pivot table&chart from table.

      

[Will Wang]

Hi Andrey,

    Yes, this is related to chart from table/pivot table, but the problem is how do we get the data on the pivot table/chart from table ?

    Do you mean to calculate the percentage in source table and use table filter to filter out this percentage ？ But after doing so, we still need to get the percentage from table filter, any way to do this ?

[Aleksandr Zuevich]

Hi Will,

As I see Pivot table and Chart are dynamic content, which is generated in VIEW mode. So you don't have possibility to refer them at other page.

@Andrey Khaneev _StiltSoft_, it looks like a good feature request - to add possibility to refer table values on another page, not just table inside macro body as it is now. (like it done in https://marketplace.atlassian.com/apps/1212655/celestecs-math-for-confluence)

[Will Wang]

Hi Aleksandr,

   Thanks anyway, let me try to insert Jquery/Javascript into excerpt to see if it may work.

[Andrey Khaneev _StiltSoft_]

Hi Will,

Yes, you can use Excerpt Include macro to place the Pivot Table macro on another page and filter it, so there will be a table with only two cells: "Sum of weight" and "97.8%".

I've added a feature request to reference / show a value from a certain cell in another place to Table Filter and Charts app backlog. I'll post here when it will be available.