User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It only takes a minute to sign up.
Sign up to join this community
For best user experience, what is the best practice for data table filters with 10+ columns?
User's Goal:
The user is trying to filter the list using of various filter types dates, number and keywords. Their end goal is to export the filtered data in CSV, PDF, etc.
A separate filter side or top panel (like in Agile CRM, Trello)
Individual filter options for each table header (like in Excel)
Solution 1. shows the filtered options while solution 2. does not.
Before any conclusion, you need to know if your users prefer or need to see the filtered options before exporting.
Another aspect to consider is whether your end-users are highly used to manipulate spreadsheets software (like Excel). This may push you towards solution 2. regardless of supposed efficiency.
Depends on what your filtering effects. If its to filter the entire table, having the filter external to the table is fine. If it is to filter a specific category it needs to be with the content it effects.
There is another filtering presentation, used in the Shield UI Grid.
I will go with option 2. IMO, as a UX/UI designer, we want to have a clean table both desktop and mobile views. Because if you have too many call-to-actions (let's say edit, delete, add, primary toggle filters, etc,.) and then if you want the filter tags to be seen then the table UI becomes cluttered.
Having the filter per column makes the table clean.
