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.
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)
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?"... ;-)
@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?
Please retest with:
I do not have enough decades in my test databases to get the same effect as you, so if some issue remains, possibly you can share your DB with me ?
1. Having too many decades to deal with, years appear averlaid each other. Vertical text will look better. (see picture)
2. I would like to see the horizontal lines (same Added Trends pattern), so it gets easier to read.
@Sven: Yes, these stats makes sense I think.
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.