[JimmXinu]

Originally Posted by version365

I installed the latest test version, it works.. I can see the new average rating is written in the book. thanks a lot..
But, I don't see any column for this to add to my custom columns, there's only 'Words' and 'Chapters'..

Site specific metadata aren't available in the dropdowns in the Custom Columns tab. You have to use custom_columns_settings in personal.ini. That way it can be different for each site.

Example with comments quoted from plugin defaults.ini:

Spoiler:

## (Plugin Only) - You can also populate calibre custom columns with
## the site specific metadata using custom_columns_settings (but only
## if 'Allow custom_columns_settings from personal.ini' is checked in
## the plugin GUI config.)  There are three parts, the entry name,
## then the label of the calibre custom column, then (optionally) a
## 'mode'.  'r' to Replace any existing values, 'a' to Add to existing
## value (use with tag-like columns), and 'n' for setting on New books
## only.  (Default is 'r'.)
## Literal strings can be set into custom columns using double quotes.
## Each metadata=>column mapping must be on a separate line and each
## needs to have one space at the start of each line.

#custom_columns_settings:
# cliches=>#acolumn
# themes=>#bcolumn,a
# timeline=>#ccolumn,n
# "FanFiction"=>#collection

[literotica.com]
add_to_custom_columns_settings:
 averrating=>#numrating

Originally Posted by version365

I see that you already added it as taking an average, which is great.
However I would like to propose that
1. If the story has 3 or less chapters, take average.
2. If the story has 4 or more chapters, keep all chapter's ratings separate while creating the book title page, but take average for the 'averrating' column value. (If that's possible and not much of a burden for you).

Let's see out the average works out for a while first. I more than half expect to find out there are stories/chapters without ratings that will cause problems.