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 can I filter tables in confluence based on column headings?

jo astley

I have tables in confluence with reams and reams of data, I need to be able to filter some of this data out based on responses to column headings.

How can I do this please?

Seems at the moment I can only filter from A-Z...or low to high. I need to filter data out not just re-organise it.

I.e. If I have a column heading which requires a yes or no response, I might need to filter out the no responses for example.

Thanks

Accepted answers

Jonathan Smith

Hi @jo astley

Tables in Confluence are pretty bland by default. I would suggest checking out StiltSoft's Table Filter macro for additional functionality.

Example in my environment:

All comments

Andrey Khaneev _StiltSoft_

Hello Jo,

Table Filter macro should help you in this case. Here you can see how it works.

Jonathan Smith

Hi @jo astley

Tables in Confluence are pretty bland by default. I would suggest checking out StiltSoft's Table Filter macro for additional functionality.

Example in my environment:

jo astley

Thank you for your response, I had seen that but was hoping confluence would have provided this by default and not as a purchased plug in.

jo astley

Thank you for your response. I had seen this macro but would have expected confluence to provide this as standard and not as a paid for plug in. Filtering data seems such a necessity. Good how they get you with all the additional add ons. Thanks again

Jonathan Smith

@jo astley I also wish Confluence tables had additional table functionality! Your only other option besides for looking into a macro is working out of a spreadsheet.

Note: If the original answer is sufficient, I would appreciate it if you marked the solution as accepted.

Thanks!

Alexi Zhang

totally agree on this. confluence cannot handle table filtering, text and font size format etc. some of the basic functions are not provided by confluence.

Confluence, pls dont make these basic features as paid services!

Sébastien NOEL

Since 2019 (date of last message in this thread)... since Confluence has evolved, is this feature not NOW embedded in Confluence itself without any add on ?

Thanks

Katerina Kovriga _Stiltsoft_

Hi @Sébastien NOEL ,

I've just answered you in another thread, so let me repeat my comment here: I'm afraid that you are right - at the moment it is not possible to filter, aggregate and calculate tabular data in Confluence out-of-the-box.

So, again we can suggest trying our app - Table Filter and Charts for Confluence (it is available for Cloud/Server/Data Center).

Maybe you'll be interested in a live demo from our team - please book a suitable time slot here. We'll be happy to show you our macros and the most common use cases.

Katerina Kovriga _Stiltsoft_

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The new macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

Dave Symonds_0px2ch

"would have expected confluence to provide this as standard and not as a paid for plug in." Thats funny

Stiltsoft support

And now you may also check two more macros from our spreadsheets' family:

The Spreadsheet from Table macro that allows you to turn your manually created and macro generated (such as Jira Issues, Page Properties Report, etc.) tables into fully functioning live sheets.
The Table Spreadsheet Include macro that allows you to reuse your spreadsheets' data across your Confluence instance.

We do hope it helps your cases!

Welcome!

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

Quick Links

Find more posts tagged with

confluence

filter

atl-gruland

table

table-filter

table-filter-and-charts

table-spreadsheet

table-filter-charts-spreadsheets