Displaying Fivestar Multi-axis Review Ratings with Views 2.x

This tutorial was using Drupal 6.11 and Fivestar 6.x-1.15.

A simple multi-axis review system can be built following the tutorial located <a href="http://drupal.org/node/430170">here (see FivestarTutorial.txt)</a>.  After this review system has been built, the display of these reviews using Views is the common next step.  This tutorial outlines a simple procedure for displaying the results of each rating axis for each node that is being rated using the system outlined in the previously mentioned tutorial.

Step 1: Have a multi-axis review system in place with at least 1 reviewable node and 2 reviews submitted for that node.

Following the previously mentioned tutorial, build a review system consisting of a "Product" node type and "Review" node type.  "Product" is the node type that will be reviewed by the "Review" node type.  "Review" node type will allow users to create reviews of Products and rate the products on multiple axes.

Once the review system is in place, make sure you have at least 1 "Product" node (call it "Product A") and 2 "Review" nodes (call them Review 1 and Review 2) created by 2 different users that rate the "Product A" node.

Step 2: Build a view that displays all "Product" nodes and the average of each rating given to each "Product" node.  Sort views by highest rating in different categories.

Go to admin/build/views and create a new view.  Give it a View name of "Products" and a View type of "Node".  Add a Page display and make the title of the page "Products and Product Ratings". Make the Style of the page a "Table" and make the Path of the page "products".  Add a field of type "Node: Title".  Add a filter of type "Node: Type" and select "Is one of" and check the node type "Product".

Now add a Relationship to the view of the type "Node: Voting results".  In the previously mentioned tutorial, the axes that were used were "reliability" and "value".  Staying consistent, give the relationship a label of "Reliability Results".  Make the Value type "Percent", the Vote tag "reliability", and the Aggregation function "Average".  Add a secon Relationship of type "Node: Voting results" - label it "Value Results", make the Value type "Percent", Vote tage "value", and Aggregation function "Average".

Now add a field of type "Voting API results: Value".  Make the Appearance "Fivestar Stars (display only), the Relationship "Reliability Results" and the Label" "Average Reliability Rating".  Add another field of the type "Voting API results: Value".  Make the Appearance "Fivestar Stars (display only), the Relationship "Value Results" and the Label "Average Value Rating".

You should now have a view that displays the Product name and the aggregate averages for each rating axis (Reliability and Value).  Now a sort can be added to this view.  Add a Sort Criteria of type "Voting API Results: Value".  Make the Relationship "Reliability Rating" and sort "Descending" to go from highest values to lowest values. This will sort the Products from highest "Reliability Rating" to lowest "Reliability Rating".  This view can then be cloned and edited so that the products are sorted by different rating axes (sort by Value rating for instance).