nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to connect table and different charts and display table data based on category clicked on chart

Gaurav Sharma_uqcqjw

I have one source table with different categories and sub categories and I would like to generate different charts for categories and sub categories with different type of statistics. This thing works If put table excerpt macro inside the chart directly. this looks ugly as I have to put table in every chart and I don't want to do that.

What I want is that, there should be only one table source on my page and when I click on any category or sub category on chart, table data should filter accordingly and show only corresponding data in the table.

This thing I implemented long back on local servers of confluence and used to work fantastically but since we moved to confluence cloud, things are not working.

Any help would be greatly appreciated.

Thank you.

Accepted answers

All comments

Jan Kuntscher - appanvil - Aura Karma Mantra

Hi,

your requierement is fully covered by our free Aura Table Filter app.

If you’d like, I’m happy to walk you through it in a short live demo.

Best regards,

Jan

Stiltsoft support

Hi @Gaurav Sharma ,

Seems that your question is related to the Table Filter, Charts & Spreadsheets for Confluence app that is ours.

Indeed there can be slight differences in the Data Center editor and new Cloud editor (the latter has several technical limitations).

For example, you may check this question about live filtration of the source table and correspondent updates to charts/pivots built from this source table: https://community.atlassian.com/forums/Confluence-questions/Dynamic-filtering-using-Table-Filter-Table-Excerpt-Include-in/qaq-p/3132429#U3132582

As we see your case, you want to have smth like this: source table <- Pivot Table <- Chart from Table. You click on the chart column and see the accordingly filtered pivot and source table. So, all you need to do is to recreate this macro sequence in the Table Toolbox macro.

If we get you wrong and you need to share more details of your page setup, please refer to our support portal directly (it is confidential and we'll be able to discuss your use cases freely).

Gaurav Sharma_uqcqjw

Which solution I should go for, if i want to keep my charts in different section of my page. When I click on any category of chat, table data (in different section) should filter out accordingly

Stiltsoft support

Not sure what you mean: if you want to keep your charts in different sections/different pages but want all of them to be built using one source table, you wrap your source table in the Table Excerpt macro and then place Table Excerpt Include macros wherever you need. This step is common for Data Center and Cloud.

The difference comes in the macro nesting: if you need to group your data before creating a chart, then on Data Center you can do it directly on the page (we mean place Chart from Table, insert Pivot Table inside its body and then place Table Excerpt Include inside the Pivot Table).

On Cloud, you place Table Excerpt Include inside the Table Toolbox macro and create the required macro sequence inside its shell. Cloud editor doesn't support direct macro nesting.

Then you click on your chart and both your grouped table and the table coming from the Table Excerpt Include macro are filtered accordingly - it works for Data Center and Cloud.

Gaurav Sharma_uqcqjw

I have a source table that I wrap it inside the table excerpt, i get it.

Then I have three different charts based on this source table. When I use table excerpt include inside table tool box--> chart and publish the page then this table starts to appear inside that chart body and effect of click(filtering) only take place on that table.

I want this this chart based filtering (using all three charts) to reflect on the source table. That's not happening.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

table

table-filter

table-excerpt

table-filter-and-charts

table-filter-charts-spreadsheets

table-toolbox