INTERACT FORUM

Please login or register.

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

Author Topic: how about an AlbumAvg() and AlbumTot() expression?  (Read 809 times)

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
how about an AlbumAvg() and AlbumTot() expression?
« on: October 19, 2010, 04:53:38 am »

so that it is possible to use total and average in thv and expressions.

 :)
gab
Logged

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: how about an AlbumAvg() and AlbumTot() expression?
« Reply #1 on: October 19, 2010, 05:03:10 am »

I think this would make a lot of people happy.

However, I use my own RATING field called, imaginatively enough, 'My Rating'.  So I'd like to see an expression along the lines of

average([my rating],[artist],[album])
total([artist],[album])

Or something like that.  Essentially a way to create an average/total count from ANY field but with the ability to filter it down to specific albums etc.

Right now I generate my own album ratings by exporting the database, doing some calcs, and the reimporting on a weekly basis.  Would be great to have functionality within MC.
Logged

Gl3nn

  • Galactic Citizen
  • ****
  • Posts: 384
Re: how about an AlbumAvg() and AlbumTot() expression?
« Reply #2 on: October 19, 2010, 10:42:18 am »

+1  I'd also like this.
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: how about an AlbumAvg() and AlbumTot() expression?
« Reply #3 on: October 19, 2010, 10:51:41 am »

i agree, mark, that that would be even nicer. but i thought since these are already available:
6.7.5 AlbumKey(...): Returns a unique album key for a file
6.7.6 AlbumArtist(...): Returns the calculated album artist for a file
6.7.7 AlbumType(...): Returns the album type for a file
that it would be a nice first step.

 :)
gab
Logged
Pages: [1]   Go Up