I have created a new content type, it's for players in our darts league and includes their name, team, most 180's and highest outshot.

I have used views to generate a block that displays a table in the order of the player that hits the most 180's.

Now I want to generate a block that displays a table in the order of players with the highest outshot. I can do it if a player has only 1 entry but some players hit 2, 3 or even 4 outshots above 100 in a session.

My question, if I enter more than 1 figure in a cell but separated by a comma (for example 121, 101), how would I get Views to display the Outshots separately in the Table so the player would have 2 separate entries?

Just so you are aware, I did try allowing Outshots to have unlimited entries and it creates multiple fields. However when I use Views to populate the table, I get the following:

Player 1 134
Player 2 121, 101
Player 3 115

What I would like to do is:

Player 1 134
Player 2 121
Player 3 115
Player 2 101

Is it possible, I appreciate your thoughts and suggestions.

Richard

Comments

rsmith77’s picture

It would appear I have managed to sort the issue so thought I should share it with the forum.

I found an old post from 2010 which related to Drupal 5 and how the user was advised to upgrade to Drupal 6 so they could make use of Views Distinct module.

I have installed this module and then simply went into the Fields option in my selected View and unticked "Display all values in the same row" under Views Distinct Settings.

Working fine.