[Lys]

Originally Posted by ownedbycats

I once requested a tweak to set the averages from a custom ratings column. Unfortunately, it was a wontfix.

Pity, maybe in the future if anyone has the interests and skills to do it. Sadly this is totally out of my skills-set

Originally Posted by BetterRed

@Lys - custom columns are attached to "books", there is no provision for attaching a custom column to an author.

So, even if an average rating were to calculated for an author, a change in rating for one book would result all the books by the same author being updated - if the book had more than one author (not uncommon in non-fiction), then all the books by all the authors.

BR

Yeah, I know: all the books "average rating for authors" being updated if I change the rating of one book would be the desired results (although IDK how much impactful something like that would be on the processing time ) while for books with more than one author my idea would be to consider them all (or none, or the first listed. I know there's no perfect solution here, if not having the average against another field which can contain one value only )

Anyway, I guess there's no easy solution to my desiderata if not downloading a catalog as CSV -> creating a pivot that calculates the averages and then manually import back the data on Calibre. And then update the data from time to time to reflect changes


Thanks for your input