View Single Post
Old 12-09-2022, 12:26 AM   #5
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,829
Karma: 30277270
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Lys View Post
Pity, maybe in the future if anyone has the interests and skills to do it. Sadly this is totally out of my skills-set



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
Hmmm - knowing what a spreadsheet pivot is, puts a a bit of a lie to your: "…but my technical knowledge is non-existent at best…"

FWIW - I maintain an "Authors library".

Items in my "Books library" link to it via a calibre://show-book/ protocol url in the Link field that's in the Manage Authors tool. And items in the Authors library link to the Books library via a calibre://search/ protocol url in the Link field.

Added: I just remembered I rate Authors rather than Books using a half-star 1-10 scale.

BR

Last edited by BetterRed; 12-09-2022 at 12:57 AM.
BetterRed is online now   Reply With Quote