Drupal 7 views - distinct not working with ordering by multiple (date) field I have "Episode" content type and some "Showing from" date field in it which is repeating (more than one value can be added). Then I have a view that list episodes ordered by that field, which works, but I want to exclude same episodes. Now if episode has i.e. 3 times that fulfill filter criteria episode will be listed 3 times. I checked "Distinct" option but it doesn't help - still episode is listed 3x.
Actually I'm not very sure how Distinct works - is it possible to select a filed that has to be distinct (if yes - how?) or it works for all fields? I would like to set distinct on episode nid of course.
Apply a filter on the date field
Select the operator: 'Is equal to', and type '0'



  When you have a multiple value field, the field has a list or array of values. delta=0 is the first value


https://www.drupal.org/node/1872262#comment-6869736