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 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.
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.
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 ?