Average of all votes for multi axis voting on a node [#1154258]

Hi,

Fivestar module has multi axis voting capability to assign multiple voting types per node, such as runner, walker, ...
At this point, in Views, I couldn't find out how to average the overall votes for a node given for each axis. For example,

runner: 80 %
walker: 40 %
overall vote: 40 + 80 / 2 = 60 %

Tried relationship with no filter for axis, it provides lists the same content multiple times in the view and it does not provide overall vote correctly.

Please let me know if there is a solution for this problem.

Thx

Comments

Comment #1

x-drup commented 30 September 2011 at 21:16

Subscribe!

Comment #2

ymeiner commented 7 October 2011 at 15:47

If you only need the number you can actualy use math field. add the fields, exclude them and calculate the result.

Comment #3

huslabs commented 16 October 2011 at 07:48

same issue !!
need to make a view sort the results by ( Who is the best !! ) ??

subscribed :)

Comment #4

x-drup commented 10 November 2011 at 21:39

/**
* Implementation of hook_votingapi_results_alter().
*/

function mymodule_votingapi_results_alter(&$results, $content_type, $content_id) {
$vote_avg_sum = 0;
$vote_avg_count = 0;
$vote_tags = 0;

foreach($results as $tag => $data) {
if($tag != 'vote') {
$vote_avg_sum += $data['percent']['average'];
$vote_avg_count += $data['percent']['count'];
$vote_tags++;
}
}
if($vote_tags > 0) {
$results['vote']['percent']['average'] = $vote_avg_sum/$vote_tags;
$results['vote']['percent']['count'] = $vote_avg_count/$vote_tags;
}
}

it works for me. in views with relation ships by axis, and sortable by votes results.