INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Library Statistics using Category View  (Read 1830 times)

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Library Statistics using Category View
« on: July 25, 2012, 05:30:28 am »

In Generating Library Statistics Reports? (now locked) I made the comment...

Quote
I do use [a Category View] occasionally when I want something more in the form of a statistical summary than a Panes View can provide. I would use it much more for that purpose if it didn't have one very limiting behaviour. That is, there's no way to select 'all' of a given category. So if I include [Decade] as a category, then I will get a summary of everything—or the last selected category value (e.g., one genre)—by decade. But then I must select a decade to go any further—so any further statistics are for that one decade only. I can, of course, revise the view to remove [Decade] or place it elsewhere in the sequence of categories included. But that ruins the otherwise dynamic nature of the report.

I just had a doh! moment as the simple solution dawned on me. Instead of defining the categories with fields, use expressions that include 'All'. Doing so is as easy as replacing [Genre], for example, with [Genre]; All&DataType=[List]. If my categories are Genre - Style - Decade - Artist - Album, I'm no longer stuck having to choose a value in each category. This means, for example, I can select Rock - ALL - 1970 and get a set of statistics (albums, tracks, duration, average number of plays) for each Style of Rock from the 1970's. The 'All' value, of course, shows the total for the group (in this case, the Rock Genre).

Another 'trick' that goes nicely with this is to include as the first category a Playlist Group that includes all Audio Playlists. One of those playlists should include all audio files—to ensure including the category does not restrict the files that may appear in the view. I've included it as a category twice to provide a means of combining two playlists. My 'All Audio' playlist is in the root folder of the group, so it can be selected easily to skip the category. One very handy playlist is [Track #]=[1] which effectively turns the view into a list of albums with [Track #] in the Categories pane showing the number of albums for whatever categories have been displayed.

As I indicated in my original post, I think this was the only barrier to such view serving reasonably well as a fully dynamic statistics report—short of pretty charts and graphs. Things like 'Top Ten Lists' aren't really necessary when they can be viewed for any measure (number of files, total duration, average number plays, etc.) just by sorting the list of categories. The list, of course, will always show the details of whatever category is selected—something a simple statistical summary cannot do.
Logged

vagskal

  • Citizen of the Universe
  • *****
  • Posts: 1227
Re: Library Statistics using Category View
« Reply #1 on: July 25, 2012, 11:27:51 am »

Pictures please. I do not fully understand.
Logged

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Re: Library Statistics using Category View
« Reply #2 on: July 25, 2012, 03:22:16 pm »

I hope these will help, although it's the sort of thing you need to try and play with a bit to appreciate. ;)

Configuration

The first image is the Customize View dialog. a.Playlists is a Playlist Group (my Audio playlists)—as shown in the second image. As mentioned, it's included twice so two playlists can be combined. The image shows how 'Genre' is defined as an expression category. Style, Decade and Artist are defined in exactly the same manner.

I probably should have illustrated something else. What is summarized at any category level depends on the sequence of categories. I've dealt with one limitation—a category can now be 'skipped' by selecting 'All'. So I can select any or all Styles and see a summary by Decade. But I can't select one Decade and see a summary by Style. That's easily remedied by adding a second occurrence of Style after Decade. I can then do it either way, using 'All' to 'skip' the one I don't want to use.

Categories View

The second image illustrates how I've used one of my smartlists to restrict the view to Original (i.e., not compilation) singe-artist albums. That's all I wanted to do, so I chose 'All Audio' at the next level. I then chose the '.rock' Genre for a list of Rock Styles (the next category). That's sorted by [Track #] to illustrate the distribution of Rock by Style.
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: Library Statistics using Category View
« Reply #3 on: July 25, 2012, 07:47:31 pm »

Pictures please. I do not fully understand.

I do.  Nice thinking, Rick.  Thanks.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

vagskal

  • Citizen of the Universe
  • *****
  • Posts: 1227
Re: Library Statistics using Category View
« Reply #4 on: July 26, 2012, 05:00:38 am »

Thanks! Now even I understand. Nice.
Logged
Pages: [1]   Go Up