Adding 1/2 star rating

[Terisa de morgan]

Thank you very much, @Mini, this is exactly what I was looking for. I've adapted a bit the method (rating + HalfS => Rating+, so I don't have to repeat wating, and as I'm drawing challenged, coud you please add an icon in rating_icons_2 for 2.5 stars? If you can't that's right but if I don't ask...

Anyway, thank you very much again.

[MiniMouse]

Originally Posted by Terisa de morgan

Thank you very much, @Mini, this is exactly what I was looking for. I've adapted a bit the method (rating + HalfS => Rating+, so I don't have to repeat wating, and as I'm drawing challenged, coud you please add an icon in rating_icons_2 for 2.5 stars? If you can't that's right but if I don't ask...

Anyway, thank you very much again.

Is up!

I also added a 0star icon. See original post here and see edit_part2 text.

Mini

[Terisa de morgan]

Thank you very much I've played around with some specific columns and half star are up A slightly different way but it works like a charm, thanks again

[chaley]

Originally Posted by MiniMouse

This is for everyone who wants a 1/2 rating for 3+ and 4+ because sure I did. AND so I created one

Using an advanced rule instead of a sequence of basic rules would have better performance. It is also easier to customize for more or fewer cases.

An example template for an advanced icon rule that returns the name of the desired png file is:

program:
# Set r to the value in a float field containing the rating
r = raw_field('#myfloat');

# Return the name of the png that corresponds to the value. The .01 stuff
# is used to avoid having to enter the png name twice, once for less-than
# and once for equals
first_non_empty(
	cmp(r, 1.01, '1-star-rating.png', '', ''),
	cmp(r, 2.01, '2-star-rating.png', '', ''),
	cmp(r, 3.01, '3-star-rating.png', '', ''),
	cmp(r, 3.51, '3-star-plus-rating.png', '', ''),
	cmp(r, 4.01, '4-star-rating.png', '', ''),
	cmp(r, 4.51, '4-star-plus-rating.png', '', ''),
	cmp(r, 5.01, '5-star-rating.png', '', '')
)

[MiniMouse]

Originally Posted by chaley

Using an advanced rule instead of a sequence of basic rules would have better performance. It is also easier to customize for more or fewer cases.

An example template for an advanced icon rule that returns the name of the desired png file is:

program:
# Set r to the value in a float field containing the rating
r = raw_field('#myfloat');

# Return the name of the png that corresponds to the value. The .01 stuff
# is used to avoid having to enter the png name twice, once for less-than
# and once for equals
first_non_empty(
	cmp(r, 1.01, '1-star-rating.png', '', ''),
	cmp(r, 2.01, '2-star-rating.png', '', ''),
	cmp(r, 3.01, '3-star-rating.png', '', ''),
	cmp(r, 3.51, '3-star-plus-rating.png', '', ''),
	cmp(r, 4.01, '4-star-rating.png', '', ''),
	cmp(r, 4.51, '4-star-plus-rating.png', '', ''),
	cmp(r, 5.01, '5-star-rating.png', '', '')
)

I think I'm a bit stupid here

Could you explain to me what to put where in the advanced rule? Because I never worked with it before

But I would really like to know

Mini

[chaley]

Originally Posted by MiniMouse

I think I'm a bit stupid here

Could you explain to me what to put where in the advanced rule? Because I never worked with it before

But I would really like to know

Mini

In Preference / Look and feel / column icons, look at the bottom of the dialog. You will see a button "Add advanced rule" (or something close to that). Tap it and a dialog will open letting you set up the rule type and the rule template. The "program:" bit I supplied is the template.

To explain a bit further, an advanced rule must return the name of the file containing the image to be displayed. If you want more than one image displayed by this one rule, return a list of image names separated by colons. If you want the results of this rule to be composed with other rules (use the results of multiple rules), pick one of the "composed" types.

In your case where you have a single image for each rating group, the advanced rule would return one name. That is what the sample template I provided does.

[Terisa de morgan]

But take into account that you must change the rules for choosing according to the value of Rating+, not the float column that chaley has analyzed.

[MiniMouse]

Originally Posted by chaley

If you want more than one image displayed by this one rule, return a list of image names separated by colons.

I think I was a bit in a rush and didn't formulated my questions too clear. I just didn't understand where to put ALL the png-files because I only could select one. But you answered that question anyway.

I will try it out.

Thanks!

Originally Posted by Terisa de morgan

But take into account that you must change the rules for choosing according to the value of Rating+, not the float column that chaley has analyzed.

And thanks for that info too because as I rushed over it, I actually did miss that part. Though it makes perfectly sense now that I think about it.

[truth1ness]

I'm trying to get finer decimal ratings (for half star or finer ratings like 4.5, 4.9, etc), too, but I'm not clear on the instructions for how to do this so far. I've made a column called ratings and set it to floating point as described. But then what? I just have an empty column now, how do I get the data from the ratings column into the decimal column? Where is the decimal rating behind the graphical stars located? Is there actual decimal data with the built in metadata download or do I need some plugin to actually grab the raw ratings again from Amazon?

[chaley]

You can transfer values from one column to another with bulk metadata search and replace.

Transferring "rating" introduces some complexity because it normally isn't a column that one can operate on. However, "template" mode lets us get its value then store it in another column. The following screen capture shows you how.

[truth1ness]

Could you explain what is going on in these fields? What is template mode, I don't see it in the dropdown or anywhere in the window.

[chaley]

Originally Posted by truth1ness

Could you explain what is going on in these fields? What is template mode, I don't see it in the dropdown or anywhere in the window.

Set the search mode to regular expression and all the options/fields/dropdowns shown in the screen capture will be available to you.