Library statistics

MarekAdam

Is it possible to view library statistics in zotero?
np. XX scientific publications, XY books, tag1 (XZ), tag2 (XX)
I know that you can filter and view the number of elements on the right, but I mean comprehensive summary statistics.

If there is no such option, is there a plugin for this?

tim820

There are snippets of javascript/SQL around here for some statistics, like tag counts and author counts. It's not too hard to devise others. Run under Tools\Developer\Run Javascript. There are no plugins that do this as far as I know.

For example to get a tabs list/count (ordered by count):

var rows = await Zotero.DB.queryAsync("SELECT name AS tagname, COUNT(*) AS num FROM tags JOIN itemTags USING (tagID) GROUP BY UPPER(tagname) ORDER BY COUNT(*) DESC");
var lines = [];
for (let row of rows) {
lines.push(row.tagname + '\t' + row.num);
}
return lines.join('\n');

To instead order the list alphabetically by tag name, replace ORDER BY COUNT(*) DESC with ORDER BY UPPER(tagname) ASC

A simple way to get counts of different item types is to have a saved search for each item type you're interested in. Given that you're probably only interested in a small fraction of all the possible item types, that's a relatively efficient process.

MarekAdam

Working, thanks!
It's a pity that there is no option to specify the number of items in collections and subcollections in () after the name :(