I've created a view called 'Browse'. I've set the 'Query Settings' to show only DISTINCT (but it doesn't work).
Background: I have a 'Resource' content type with a field list field called 'type'. Types may include 'blog', 'book', 'web article', etc. (there are only 8 types). I have about 80 resources in this content type, each with a 'type'.
When I create my view with DISTINCT set and content type=resource and 'type' as the only field it displays about 15 instances of each type, so it ends up looking something like this:
Blog Blog Blog ... Book Book Book Book ... Web Article Web Article etc.
I only want each 'type' to display once and link to the views I've already setup that show all the resource content types with that particular type set (ie. if a user clicks 'blog', which should only appear once, it takes them to a page view listing all the blogs in the db.
Does anyone know how to ensure my View shows only distinct values for items in this field_list?