1148: Statistics messed up

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: 1148: Statistics messed up

by Ludek » Fri Apr 04, 2008 8:33 am

Btw. Starting from build 1155 the stats.vbs is corrected based on your complaint.

i.e. the Sum( PlayCounter) is the indicator and also "Top 10 ALbums" has been improved - the column 'Tracks' has been replaced by 'Rating' and top 10 albums list is now shown based on avarage rating.

by Guy-I » Thu Apr 03, 2008 2:11 pm

Yes!! That's it.
Thank you very much.
I really love this Top10-lists and now I got the old form back.

by Ludek » Wed Apr 02, 2008 12:53 pm

Re: Top 10 Albums Played, Top 10 Artists Played
Yes, the determinant here is "How many songs of this album/artist have been played"

e.g.
Album1: 20 tracks and 18 of them have been played only once.
Album 2: 15 tracks and all 15 track have been played 6 times.

The Album1 will be higher because more tracks of this album have been played.

Do you think that there should be another determinant/indicator related to playcount?

You might be right. Then the SQL query in the Stats.vbs needs to be modified slightly:
i.e. Replace Count(Songs.ID) by Sum( PlayCounter)
in Scripts\stats.vbs on the lines 685 (twice - also in ORDER BY part) for Top 10 Artists Played and on the lines 746, 752 for Top 10 albums Played


Edited: I meant Sum( PlayCounter)

by Guy-I » Wed Apr 02, 2008 11:52 am

Hello Ludek, thank you for response.
The average lines seem to be correct.
The problem only concerns the Top 10-lists (Top10 played artists and top10 played albums). A new list Top10 albums wasn't there before but it only lists albums I only played a few times and my real top albums doesn't even appear in the statistics.
I also rescanned the library, but still no change.

by Ludek » Wed Apr 02, 2008 7:07 am

Guy, in build 1147 some SQL queries were optimized in the script in order to speed up the report process. It was slow on some very large DBs. It is possible that there could be a regression, but rather many SQL queries related mailnly to 'played' values have been corrrected.

Could you give me an exact line which is reported badly for you?
e.g.
Page: Avagares
Line: Tracks per Artist

1148: Statistics messed up

by Guy-I » Tue Apr 01, 2008 2:43 pm

Hello
Since build 1148 my MM statistic is completely messed up.
I don't know what it is. The play-count of the mp3s ist still correct but the statistic appears to be several years old.
Seems like the past years haven't been counted.
Any solution for that?
Reinstalling build 1147 brought no change.

Top