6

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) A seperate filter side or top panel (like in agile crm, trello)

enter image description here

b) Individual filter options for each table headers (like in excel)

enter image description here

  • Can you give more context of what the user is trying to do? What's the domain, and is the app used by experts on a frequent basis? Any mocks will help us to assess your situation. – Mike M Jul 7 '17 at 6:30
  • 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. – Saroj Shahi Jul 20 '17 at 5:29
  • 1
    Do you have any research on the filters? You may find many of them remain completely unused. Secondly, you're comparing apples with oranges. Excel's filters are taken from values in the column, the top example is the name of the column, and you supply the value. – DarrylGodden Jul 20 '17 at 7:24
3

Solution A shows the filtered options while solution B 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 weather your end-users are highly used to manipulate spreadsheets software (like Excel). This may push you towards solution B regardless of supposed efficiency.

1

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.

  • Yes, the filter effects the entire table. 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. – Saroj Shahi Jul 20 '17 at 5:30
1

There is another filtering presentation, used in the Shield UI Grid.

0

I will go with option B. IMO, as a ux/ui designer we want to have a clean table both desktop and mobile views. Because if you have to 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 become cluttered.

Having the filter per column makes the table clean.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.