How to find the ID for a table to use in a Bar Chart macro?

[Katarina Palm]

Hi!

I am trying to create a Bar chart using the Chart macro. I have filter for the data I want to show; works fine with a standard pie chart. But when creating a bar chart, I am expected to enter a comma separated list for the table ID(s) to use. I have tables of data on my page,  How do I find table IDs?

[Katerina Kovriga {Stiltsoft}]

Hi @Katarina Palm ,

As I understand from the Atlassian documentation, the table id selection may be only required if your page structure is very complex, for example, you use section and column macros inside the chart macro body and your tables are all mixed up.

If you use a simple layout, then it is not necessary to fill in this field and you may leave it blank:

The standard Chart macro is not very flexible (besides it doesn't work with the dynamic macros), so we can recommend to use the Chart from Table macro provided by the Table Filter and Charts for Confluence app.

Let's take the same table as an example:

As you can see, you can filter what items to include into your chart.

This example was created for the Horizontal table orientation:

And now let's choose the vertical one:

Our chart has changed - now you can choose which form is more relevant to your case.

[Michelle Rau HP]

Oh man, I got this to work once and now I can't remember all the details!

The documentation says "Comma separated list of table ids and/or table numbers (starting at 1) ."

Within the Chart macro, you can have more than 1 table. By default, it appears that the Chart macro will chart the data from all the tables within the macro (combines data). If you tell it table ID 1, then it will only chart the data from the first table. If you tell it table ID 2, then it will only chart the data from the second table, and so on.

https://support.atlassian.com/confluence-cloud/docs/insert-the-chart-macro/ 

[trobbs]

The link provided doesn't work (extra characters at the end) so here's a link that does.

[Katarina Palm]

Thanks! I saw this option in other answers, but I am primarily looking for a solution within the standard product. Seems it is not very well supported, tough...

BRs, Katarina