[Digikam-users] Rating Pyramid (database subset statistics)

[Peter Shute]

It sounds like the sort of thing that would be fairly simple if you queried the database directly with SQL commands. Grouping by rating could give you the counts for each rating with one query, if that's what you mean, grouped by year, etc, if necessary. Does anyone know how to access the database directly? Is there a recommended front end?

I would have simply called it the ratings counts. It's only a pyramid if you get more bad shots than good shots, which is true for most of us, of course.


--------------------------
Sent using BlackBerry

________________________________
From: Mattias Carlsson
To: digikam-users at kde.org
Sent: Sun Apr 11 23:28:38 2010
Subject: [Digikam-users] Rating Pyramid (database subset statistics)

Having rated a bunch of images, I would like to see a rating statistics, e.g. a rating pyramid as presented at http://docs.kde.org/development/en/extragear-graphics/digikam/dam.html. Now, I know it would be possible to choose advanced filter for each of the rating and picture subset, noting the number of item for each rating in e.g. Spreadsheet and then compare to an "optimal" rating pyramid, but this would be inflexible to use for different subsets.

It would be slick to have a function where you can select any subset of pictures and choose to get a "rating pyramid" displaying the rating ratio for the selection. A graphic pyramid could simplify the viewing of the skewing, but just numbers in a table would suffice together with the recommendation from e.g. the posted link and maybe also a "diff ratio" for each rating to highlight the skewing of the rating.

Is there some existing way to do this, or is this a feature that anyone else also would find useful?

Regards,

Mattias

________________________________
Hotmail: Powerful Free email with security by Microsoft. Get it now.<https://signup.live.com/signup.aspx?id=60969>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20100412/0c01c1fd/attachment.html>