I would like to see the distribution by year of my entire collection. Something looking like "Played Weeks" in "Listening Habits", but by year in collection instead.
My interest is from tag (release year), but a configuration option would be nice, so we can have other visions and it can also be useful to other people as well, selecting favourite one for daily use.
SELECT relyear, Count(Detail_ID) FROM `tbldetail` WHERE relyear > 0 GROUP BY relyear ORDER BY relyear ASC
This gave me different values than Helium did.
SELECT ReleaseYear, SUM(TotalItems) FROM `tblalbums` WHERE ReleaseYear > 0 GROUP BY ReleaseYear ORDER BY ReleaseYear ASC
Which creates the same values as Helium does, so there's somewhere somehow a discrepancy between my tracks and album tables...
So the question mark above my head does not mean "Where do you get your values?" anymore, but "Why is there a discrepancy in my database?"... ;-)
If the database comes from an old Helium version it might be caused by this. Someway back in time (Helium 10.x something) album summary updates was not always properly executed, something that was corrected in Helium 11.
The best idea I got is that you create a script that executes some SQL per-album that will update the item count (possibly)
@Sven: Typo fixed for next build. A new tab will not be created for now.
>>Now I have a big question mark above my head...
Not sure what to do with this one, I did some quick tests which seemed correct. Bad data in database?
Any reproduction possible?
SELECT ReleaseYear, COUNT(Album_ID) FROM `tblalbums` WHERE ReleaseYear > 0 GROUP BY ReleaseYear ORDER BY ReleaseYear ASC
and Tracks by Recording Year
SELECT recyear, Count(Detail_ID) FROM `tbldetail` WHERE recyear > 0 GROUP BY recyear ORDER BY recyear ASC
would be my wish to see.
@Sven: Yes, these stats makes sense I think.