Hey all,
I'm looking for a Global that will return a single value that reflects the usefulness of a review. On the reviews there's an option to indicate whether a review was useful or not. Depending on what you choose it increments either the Review_WasHelpful or Review_WasNotHelpful fields.
sounds like it should be easy from this to figure the total number of votes submitted and which percentage was positive.
Below is a piece of code I use to return a value based on the rating average (which is already calculated by the script). I'd like to return a single percentage value for the "usefulness" as well to display a graphic star-indicator.
Can you help?
my ($rec) = @_;
if ($rec->{'Rating'} eq '10.00') {'50'; }
elsif ($rec->{'Rating'} eq '0.00') {'00'; }
elsif ($rec->{'Rating'} eq '') {'00'; }
elsif ($rec->{'Rating'} le '0.25') {'00'; }
elsif ($rec->{'Rating'} le '0.50') {'05'; }
elsif ($rec->{'Rating'} le '0.75') {'05'; }
elsif ($rec->{'Rating'} le '1.00') {'05'; }
elsif ($rec->{'Rating'} le '1.25') {'05'; }
elsif ($rec->{'Rating'} le '1.50') {'10'; }
elsif ($rec->{'Rating'} le '1.75') {'10'; }
elsif ($rec->{'Rating'} le '2.00') {'10'; }
elsif ($rec->{'Rating'} le '2.25') {'10'; }
elsif ($rec->{'Rating'} le '2.50') {'15'; }
elsif ($rec->{'Rating'} le '2.75') {'15'; }
elsif ($rec->{'Rating'} le '3.00') {'15'; }
elsif ($rec->{'Rating'} le '3.25') {'15'; }
elsif ($rec->{'Rating'} le '3.50') {'20'; }
elsif ($rec->{'Rating'} le '3.75') {'20'; }
elsif ($rec->{'Rating'} le '4.00') {'20'; }
elsif ($rec->{'Rating'} le '4.25') {'20'; }
elsif ($rec->{'Rating'} le '4.50') {'25'; }
elsif ($rec->{'Rating'} le '4.75') {'25'; }
elsif ($rec->{'Rating'} le '5.00') {'25'; }
elsif ($rec->{'Rating'} le '5.25') {'25'; }
elsif ($rec->{'Rating'} le '5.50') {'30'; }
elsif ($rec->{'Rating'} le '5.75') {'30'; }
elsif ($rec->{'Rating'} le '6.00') {'30'; }
elsif ($rec->{'Rating'} le '6.25') {'30'; }
elsif ($rec->{'Rating'} le '6.50') {'35'; }
elsif ($rec->{'Rating'} le '6.75') {'35'; }
elsif ($rec->{'Rating'} le '7.00') {'35'; }
elsif ($rec->{'Rating'} le '7.25') {'35'; }
elsif ($rec->{'Rating'} le '7.50') {'40'; }
elsif ($rec->{'Rating'} le '7.75') {'40'; }
elsif ($rec->{'Rating'} le '8.00') {'40'; }
elsif ($rec->{'Rating'} le '8.25') {'40'; }
elsif ($rec->{'Rating'} le '8.50') {'45'; }
elsif ($rec->{'Rating'} le '8.75') {'45'; }
elsif ($rec->{'Rating'} le '9.00') {'45'; }
elsif ($rec->{'Rating'} le '9.25') {'45'; }
elsif ($rec->{'Rating'} le '9.50') {'50'; }
elsif ($rec->{'Rating'} le '9.75') {'50'; }
else {'50'; }
}
Safe swoops
Sangiro
I'm looking for a Global that will return a single value that reflects the usefulness of a review. On the reviews there's an option to indicate whether a review was useful or not. Depending on what you choose it increments either the Review_WasHelpful or Review_WasNotHelpful fields.
sounds like it should be easy from this to figure the total number of votes submitted and which percentage was positive.
Below is a piece of code I use to return a value based on the rating average (which is already calculated by the script). I'd like to return a single percentage value for the "usefulness" as well to display a graphic star-indicator.
Can you help?
Code:
sub { my ($rec) = @_;
if ($rec->{'Rating'} eq '10.00') {'50'; }
elsif ($rec->{'Rating'} eq '0.00') {'00'; }
elsif ($rec->{'Rating'} eq '') {'00'; }
elsif ($rec->{'Rating'} le '0.25') {'00'; }
elsif ($rec->{'Rating'} le '0.50') {'05'; }
elsif ($rec->{'Rating'} le '0.75') {'05'; }
elsif ($rec->{'Rating'} le '1.00') {'05'; }
elsif ($rec->{'Rating'} le '1.25') {'05'; }
elsif ($rec->{'Rating'} le '1.50') {'10'; }
elsif ($rec->{'Rating'} le '1.75') {'10'; }
elsif ($rec->{'Rating'} le '2.00') {'10'; }
elsif ($rec->{'Rating'} le '2.25') {'10'; }
elsif ($rec->{'Rating'} le '2.50') {'15'; }
elsif ($rec->{'Rating'} le '2.75') {'15'; }
elsif ($rec->{'Rating'} le '3.00') {'15'; }
elsif ($rec->{'Rating'} le '3.25') {'15'; }
elsif ($rec->{'Rating'} le '3.50') {'20'; }
elsif ($rec->{'Rating'} le '3.75') {'20'; }
elsif ($rec->{'Rating'} le '4.00') {'20'; }
elsif ($rec->{'Rating'} le '4.25') {'20'; }
elsif ($rec->{'Rating'} le '4.50') {'25'; }
elsif ($rec->{'Rating'} le '4.75') {'25'; }
elsif ($rec->{'Rating'} le '5.00') {'25'; }
elsif ($rec->{'Rating'} le '5.25') {'25'; }
elsif ($rec->{'Rating'} le '5.50') {'30'; }
elsif ($rec->{'Rating'} le '5.75') {'30'; }
elsif ($rec->{'Rating'} le '6.00') {'30'; }
elsif ($rec->{'Rating'} le '6.25') {'30'; }
elsif ($rec->{'Rating'} le '6.50') {'35'; }
elsif ($rec->{'Rating'} le '6.75') {'35'; }
elsif ($rec->{'Rating'} le '7.00') {'35'; }
elsif ($rec->{'Rating'} le '7.25') {'35'; }
elsif ($rec->{'Rating'} le '7.50') {'40'; }
elsif ($rec->{'Rating'} le '7.75') {'40'; }
elsif ($rec->{'Rating'} le '8.00') {'40'; }
elsif ($rec->{'Rating'} le '8.25') {'40'; }
elsif ($rec->{'Rating'} le '8.50') {'45'; }
elsif ($rec->{'Rating'} le '8.75') {'45'; }
elsif ($rec->{'Rating'} le '9.00') {'45'; }
elsif ($rec->{'Rating'} le '9.25') {'45'; }
elsif ($rec->{'Rating'} le '9.50') {'50'; }
elsif ($rec->{'Rating'} le '9.75') {'50'; }
else {'50'; }
}
Safe swoops
Sangiro
Global: Averaging Usefulness of Reviews