Unable to sort view by rating

Thanks for this video link Steve.

Working on my D7 site, I found that the "appearance" element in Views that the video refers to doesn't seem to be found anywhere in Views 3, thus making it difficult to get the actual rating stars in a table column.

The approach I found to use was as follows:
1) As per the video, add the relationship: Content: Vote results and select "Value Type: Percent; Vote Tag: Vote, Aggregation function: Average"
2) Add the field: Content: Rating, but check "Exclude from display" - this column allows us to show the star rating, but because it does not include the actual average vote value, it does not correctly sort your results by top rating. Thus, we'll exclude it from displaying, but still need it there as you'll soon see
3) Add the field: "(Vote results) Vote results: Value (Rating)" and AGAIN, check "Exclude from display"
4) In the "(Vote results) Vote results: Value (Rating)" field settings, go down to "Rewrite Results" and check "Rewrite the output of this field", then in the text box below, enter the following replacement pattern:
[field_rating]

By doing this, you get the benefit of sorting the column by Vote results: Value (Rating), but show the actual star rating.

Hope this helps,

ruess

#2 works, but did not need excluded fields.
Here is how I did it.
1. Add all fields you want to to display in the view as normal.
2. Add new relationship to Content: Vote results.
3. Choose appropriate settings here. In my case, i wanted to show top rated providers list so I added Percentage, overall as the tag (default tag is "vote". Choose what you want) and average as aggregate method.
4. Add new sort criteria: Vote results: value. For top rated items, choose descending.

Sorry for bumping this issue - just wanted to share a simple way for googlers.

Thanks all - helpful...
I had to use "percentage" for the sorting value.
"points" didn't do anything.

OK #3 worked awesome for me.