Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Humbledore]

Hi,
is it a way in MC to sort album on their tracks average rating?
Thanks

[MrC]

You can sort the Categories by average rating.  Just select Sort > Rating from the Tab's pull down.

You can sort the contents of a pane by average rating: Customize the view, select the pane's column to be sorted from under Show Categories In This Order and press Edit.  Change the Settings > Sorting to Rating.

You cannot really sort by Average Rating in a File List, because Grouping and Sorting are one and the same and sorting is alphabetic, so if you group by Album, then the sorting is by Album (actually, Artist, Album, and Date), but if you group by Rating, then your albums will be split based on each unique track rating.

[Humbledore]

Thanks,
But what I would like to achieve is an exact average calculation. For example, if an album has four 5 stars rated tracks and four 1 star rated tracks, the album average should become 3. Now it doesn't seem to work that way.
And it would be nice if MC then could group the albums by an average interval like 4.5-5, 4.0-4.5 and so on... :-)

 

[MrC]

You haven't indicated where you want the grouping.  By Categories in a categories view?

[Humbledore]

Actually, it doesn't matter where the grouping is taking place. I just wonder if it's possible to accomplish an album view with sorting on average album rating, preferably grouped by some rating interval mentioned in the previous post.
Thanks!

[MrC]

Here's a panes view where the first column is sorted by Rating (its the average rating) and the second column shows the rating groups, using the display expression:

save(replace(GroupSummary(Rating), / avg,),avgrating)/
ifelse(
   Compare([avgrating], <=, 0.5), 0.0 - 0.5,
   Compare([avgrating], <=, 1.0), <0.5 - 1.0,
   Compare([avgrating], <=, 1.5), <1.0 - 1.5,
   Compare([avgrating], <=, 2.0), <1.5 - 2.0,
   Compare([avgrating], <=, 2.5), <2.0 - 2.5,
   Compare([avgrating], <=, 3.0), <2.5 - 3.0,
   Compare([avgrating], <=, 3.5), <3.0 - 3.5,
   Compare([avgrating], <=, 4.0), <3.5 - 4.0,
   Compare([avgrating], <=, 4.5), <4.0 - 4.5,
   Compare([avgrating], <=, 5.0), <4.5 - 5.0,
   1, Other
)

[Humbledore]

MrC, thank you very much! It seems to be exact what I'm looking for.    I'll try your solution in a couple of days, a bad cold has attacked me. Time for rest...

[Humbledore]

I noticed that your average computation doesn't reflect unassigned tracks, see attached image. Is it possible to include them as well?
And as you also can see, the same rating group repeat itself, which looks a bit clumsy. And there is only one album per group... Maybe I have missed something?
Thanks!  

[MrC]

The identical category entries seems to be a bug with how the new Expression to Group/Expression to Display category view is being handled.  I also note that sorting does not work correctly here.

Since we don't have any control over what GroupSummary() is actually doing with Rating, and it appears to ignore Unassigned values in averages, we'd have to use the global variable technique instead to calculate average ratings that include penalizing for tracks that have no ratings.  Somewhere I've posted on this, ask if you don't find it.

[Humbledore]

MrC, anyway, thank you for your efforts to improve user features! :-)  

And if any MC developer read this; if would be very nice if an albums categories thumbnails view also could be sorted on album average rating.
Thanks!

[Humbledore]

Since we don't have any control over what GroupSummary() is actually doing with Rating, and it appears to ignore Unassigned values in averages, we'd have to use the global variable technique instead to calculate average ratings that include penalizing for tracks that have no ratings.  Somewhere I've posted on this, ask if you don't find it.

MrC, can you help me find your post!
Thanks!

[MrC]

I can't find the thread on first look.  It is possible that the discussion was either via email or PM.  In any case, how do you want to penalize non-rated tracks?  Should they be considered as 0 stars?

[Humbledore]

What I would prefer is a graphical thumbnails view showing the albums sorted by album rating. In my opinion non-rated tracks should NOT be penalized, because there is a big chance they just haven't been rated yet. So they should be excluded for the average calculation. (Tracks I really don't like are set to one star...)
Thanks!

[MrC]

I found the thread:

    http://yabb.jriver.com/interact/index.php?topic=72049.msg556135#msg556135

If you need me to provide the rules, let me know.

[Humbledore]

Thanks, do you mean that this code does the trick?:

[=save(0,v_ntracks_[AAA])1]=1 [=save(0,v_duration_[AAA])1]=1 [=save(0,v_trating_[AAA])1]=1 [=ifelse(!isempty([_Rating (track)]),save(math(1 + load(v_ntracks_[AAA])), v_ntracks_[AAA]))1]=1 [=ifelse(!isempty([_Rating (track)]),save(math([duration,0] + load(v_duration_[AAA])),v_duration_[AAA]))1]=1 [=ifelse(!isempty([_Rating (track)]),save(math([_Rating (track)] * ([duration,0] / load(v_duration_[AAA]))), v_trating_[AAA]_[name]))1]=1 [=ifelse(!isempty([_Rating (track)]),save(math(load(v_trating_[AAA]_[name]) + load(v_trating_[AAA])),v_trating_[AAA]))1]=1 ~sort=[Disc #],[Track #]

I would be much grateful if you could provide me the rules so I know how to add the code into MC.

Thanks a lot!

[MrC]

That's the idea, but it does more than what you were asking.  Here is search expression to use in Set rules for file display for the view:

Code: [Select]

[=1save(0,v_ntracks_AlbumKey())]=1 [=1save(0,v_rating_AlbumKey())]=1 [=1ifelse(!isempty([Rating]),saveadd(v_ntracks_AlbumKey(), 1))]=1 [=1ifelse(!isempty([Rating]),saveadd(v_rating_AlbumKey(), [Rating]))]=1 ~sort=[Disc #],[Track #]
Here is a Panes column expression or Category expression to use:

Code: [Select]

save(math(load(v_rating_AlbumKey()) / load(v_ntracks_AlbumKey())),avgrating)/
ifelse(
   Compare([avgrating], <=, 0.5), 0.0 - 0.5,
   Compare([avgrating], <=, 1.0), <0.5 - 1.0,
   Compare([avgrating], <=, 1.5), <1.0 - 1.5,
   Compare([avgrating], <=, 2.0), <1.5 - 2.0,
   Compare([avgrating], <=, 2.5), <2.0 - 2.5,
   Compare([avgrating], <=, 3.0), <2.5 - 3.0,
   Compare([avgrating], <=, 3.5), <3.0 - 3.5,
   Compare([avgrating], <=, 4.0), <3.5 - 4.0,
   Compare([avgrating], <=, 4.5), <4.0 - 4.5,
   Compare([avgrating], <=, 5.0), <4.5 - 5.0,
   1, Other
)

The number of tracks per album is stored in the global variable v_ntracks_AlbumKey() and the cumulative rating for the album is stored in v_rating_AlbumKey().  The math() expression does the averaging:

   math(load(v_rating_AlbumKey()) / load(v_ntracks_AlbumKey()))