in ROON user interface
History cannot be filtered, (group by artist, or group by album.)
a big miss in your software
You might want to vote for this Feature Suggestion - it could do with some love.
Enable focus/searching/filtering of history - Feedback / Feature Suggestions - Roon Labs Community
The workaround is to make a Playlist from your History and then Export it to Excel for slicing and dicing.