I have a playlist, created from Magic Nodes, that shows albums with a weighted average of 3 stars or better. See below.
<Group|Name:Album Ratings|Show tracks:No>\Albums with weighted avg. track rating >= 3 stars and at least 5 rated tracks|Icon:Top level|Filter:Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating >= 0 GROUP BY IDAlbum HAVING Sum(SongLength * Rating) / Sum(SongLength) >= 60 AND Count(Rating) >= 5)|Child of:Playlists|Position:Child\<Album|Sort by:Avg(Rating)|Statistic:Count(All)>
Is there a way to run a report that would then list these albums with their particular rating? I don't even know where this information is stored (I'm going to guess in the database) and I have no idea how to retrieve it.
I think it would be cool to see the actual numerical rating for the albums in this playlist. Is it possible?
It can calculated on the fly. A general rule of databases is not to store data that is redundant. As the Album Rating depends on Track Rating it is redundant and should be calculate when needed (for display).