Greetings. First of all thank you. I understand how to create a llist of the highest rated nodes per average through using views.

However, I am having a very hard time trying to create a list of highest average nodes containing a selected taxonomy term.

For instance I have:
Node A
Taxonomy Category 1
Term "A"
Node B
Taxonomy Category 1
Term "A"
Node C
Taxonomy Category 1
Term "B"
Node D
Taxonomy Category 1
Term "B"

I am trying to create a block which rates by Ascending or Descending Average vote of a Taxonomy category:

For Example:
Taxonomy Category 1 Leader board
All of Nodes which contain Taxonomy Category 1 Term A which have been voted for Total Average - Example: Total Voted average 80%
All of Nodes which contain Taxonomy Category 2 Term B which have been voted for Total Average - Example: Total Voted average 70%

Right now the best I can o is Get this:
Category 1
Term A Average 70%
Term A Average 60%
Term B Average 40%
Term B Average 30%

I can see the terms repeated and the individuals node containing that terms average. I need to have the total of each node containing the selected Taxonomys Category Term added together and created an averaged, then sorted by ascending or descending. I have tried for many hours in veiews to do this but I cant figure it out. If someone could elp me I would really appreciate it.

So to summerize I am trying to get

Taxonomy Category 1 Leaderboard
Term A Average (ie. 70%) + Term A Average (ie. 60%) = Term A total voted Average
Term B Average (ie 40%) + Term B Average (ie, 30%) = Term B Total voted Average

Thank you so much for any help you can give me

Comments

AntiNSA’s picture

AntiNSA commented
Title: How to get averag rating for all nodes which are voted on and contain a selectd taxonomy term? » How to create list of taxonomy term items grouped and ranked by average rating for all voted on nodes containing that term?

How to create list of taxonomy term items grouped and ranked by average rating for all voted on nodes containing that term?

I am not sure if I a explaining this correctly...

AntiNSA’s picture

AntiNSA commented
Title: How to create list of taxonomy term items grouped and ranked by average rating for all voted on nodes containing that term? » How to create list of Combined TOTAL average ratings for voted on nodes containing a selected taxonomy item vocabulary term?

Perhaps this is a better title?

"How to create list of Combined TOTAL average ratings for voted on nodes containing a selected taxonomy item vocabulary term?"

EvanDonovan’s picture

EvanDonovan commented
Priority: Critical » Normal

Is this using Views?

Support requests are never critical, unless it's a bug, in which case use "bug report" for category.

cfbauer’s picture

cfbauer commented

I would also like to do this. For example, 5 nodes rating Camrys, Corollas, Priuses, etc. with the Toyota taxonomy, then a view that shows the average rating for all Toyotas.

shiolo’s picture

shiolo commented

I'm trying to achieve the exact same thing that cfbauer is trying, any help will be thanked!

zualas’s picture

zualas commented

In Drupal 6 you can use the Table Wizard module and expose the table with votes to Views and use some PHP fields to pass arguments correctly.

This option is not available in Drupal 7, so if anyone has found a solution, that would be great.

cfbauer’s picture

cfbauer commented

Anyone want to try to crowd fund? I've seen a few requests for this feature, I'd be willing to drop some money for it.

edit: Whoops, didn't mean to make a revision. I'm new to Drupal.org

zualas’s picture

zualas commented
Status: Active » Fixed

After a few false tries, I could make it work quite simply out of the box in Drupal 7 Views. I'll try to describe the steps.

1) Create a taxonomy term view and select the vocabulary you need
2) In the new view, add a Relationship for "Content with term"
3) Add your taxonomy term name in the fields if not already there
4) Enable aggregation
5) Add your fivestar field (I have fivestar widget as field, not a node vote, but not sure if it matters)
6) For the added fivestar widget, set the aggregation to "Average"

NB! Do not add any extra fields not related to the average vote. Aggregation uses unique values in all fields, so if you have more than just the necessary for voting, the average may not function properly.

You can of course use the contextual filters to rule out unnecessary stuff and Sorting to sort by your fivestar rating.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.