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

[Jonathan Smith · Accepted solution]

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 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!

[Dave Symonds]

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

[Andrey Khaneev _StiltSoft_]

Hello Jo,

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

[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.

[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!

[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.

[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!

[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.