INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: gappie on November 08, 2006, 11:34:49 am

Title: using AVERAGE in expressions.
Post by: gappie on November 08, 2006, 11:34:49 am
i asked about it when i started to use mc11, and it was not possible then. but since 12 is giving the avg values for number plays etc, i was wondering if it is possible now to make expressions with it.

for instance, when i want to have my 150 least played albums sort them random and take 21 out of those, i get indeed records that are not played so often but 90% has an higher avg then what the least played 150 albums have.
here is the code i use:
~a ~sort=[number plays] ~limit=150,-1,[Album],[Album Artist (auto)] ~sort=[Random] ~limit=21,-1,[Album],[Album Artist (auto)]