Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,132
Community Members
 
Community Events
168
Community Groups

How can I filter tables in confluence based on column headings?

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

4 answers

1 accepted

1 vote
Answer accepted

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:

x.jpg

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

Like # people like this

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

Like jo astley likes this

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

Like # people like this

Hello Jo,

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

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.

Like # people like this

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!

Like # people like this

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.

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

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.

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Watch 4 Confluence apps compete for Best App Demo in September's Appy Hours

Calling all collaborators! Appy Hours on the Atlassian Community is a monthly event where 4 Partner and app vendor presenters go head-to-head with 5-minute demos for the title of Best App Demo. I...

524 views 0 12
Read article

Atlassian Community Events