Filtered Statistics Report 1.5.1 (2009-10-09) [MM3]

[ZvezdanD]

The play count is an information from the Songs table which is now used in the reports. As I said, I suppose that MM during sync with iPods updates that information only (and maybe Last Played Date which is also in Songs table) instead of the Played table which contains informations about playing date/time for each playing. In theory, the number of record in the Played table should be same as a sum of the play counts from the Songs table, but if MM updates only the Songs table during iPod sync then the play count is more accurate than number of records from Played table.

[RobertSmith]

There is a new release (1.4.1), please let me know if it works as it should. I don't have an iPod, so I cannot test it.

It works perfect, once more many thanks for all great scripts!!

A little O.T.
The extremely fast response is fantastic. Just think if M$ or Apple could open where products for all great programmers out where. I have been writing to apple for the last three year trying to convince them to come with an update so podcast mp3 is only found in the podcast folder and not mixed up with songs and artists, it must be where easy to use genre, but no luck so far...

[RobertSmith]

What do you think about a options to select minimum no of tracks (no CDS/CDM) and/or minimum no tracks with rating, minimum X no tracks from one artist (avoid one hit artist from VA album) or is it better to solve this using MM filter?

[Mizery_Made]

The filter ability was pretty much added to do things like this, and since it's accomplish-able through filters, I don't see a need to hard code the option into the script. Though I'm not the scripts author, so he might feel differently.

[RobertSmith]

I don't see a need to hard code the option into the script.

No hard code, an option were you could select the number. If you set it to 0 (zero) it would be exact as now, but if you for instance set minimum tracks from one artist to 5 you can avoid one-hit wonders, or minimum 8 rated tracks per album you avoid CDS/CDM and albums there you only has play/rate a few tracks (VA/compilations albums). But as you said it's up to the author

[ZvezdanD]

I don't see a need to hard code the option into the script.

No hard code, an option were you could select the number. If you set it to 0 (zero) it would be exact as now

How do you expect this to work if necessary SQL queries are not hard-coded into the script? As Mizery_Made said, it would be better if you use MM filters for that. Anyway, I have another idea how to use different SQL queries to get statistical reports without a need to hard-code them into the script (I already talked about it), but there are some more important things that should be done first.

[RobertSmith]

it would be better if you use MM filters for that.

But the MM filter it not so bright (or maybe it's me that have misunderstand the function), e.g. with # Tracks by artist => 100 I expect a report with only my favourites but in top of chart I have Chrissi Poland since he is feat. artist on one Moby album (I'm using multi artist) (not possible to have # Album Artist => 100)

[ZvezdanD]

e.g. with # Tracks by artist => 100 I expect a report with only my favourites but in top of chart I have Chrissi Poland since he is feat. artist on one Moby album (I'm using multi artist) (not possible to have # Album Artist => 100)

Well, even if I decide to add such option, I still don't understand on which sections it should be applied. For example, limiting artist only to those which have number of tracks greater than xx has not much sense for Top xx Artist With Most Tracks section.

[RobertSmith]

Well, even if I decide to add such option, I still don't understand on which sections it should be applied. For example, limiting artist only to those which have number of tracks greater than xx has not much sense for Top xx Artist With Most Tracks section.

If you limit # of tracks to 5-8 per artist (minimum for calc. average) you will avoid one-hit wonders and featured artist (multi) in "Top-XX Rated artist" the effect on "Top XX Artist With Most Tracks" is unimportant since position XX (according to personal settings) will be greater when the track limit 5-8. If not, you have a very small collection and no need for MM

Most of filtering could be done with MM, but not all. Avoiding CDS/CDM etc. could be done with MM filter since I have (CDS), (VLS) etc. in album title. I believe all sections looks OK with the exception of the rated once.
Maybe it's enough to have an option to select minimum # tracks per artist. I can live with what some of my albums looks strange due to what I haven't rated the complete album (minimum 5-8 tracks per album must be rated before an average is calculated?)

Edit: minimum 5-8 tracks per genre must be rated before an average is calculated. Top XX Rated Genre

[ZvezdanD]

Maybe it's enough to have an option to select minimum # tracks per artist. I can live with what some of my albums looks strange due to what I haven't rated the complete album (minimum 5-8 tracks per album must be rated before an average is calculated?)

Edit: minimum 5-8 tracks per genre must be rated before an average is calculated. Top XX Rated Genre

There are currently 24 sections and I need some simple and obvious way to implement just one or two new values for all sections. For example, if a section is Album then limit could be a minimal number of tracks per album, if a section is Artist then limit could be a minimal number of tracks per artist, and so on. So, what should be a criteria? Minimal number of tracks or minimal number of rated tracks or minimal number of played tracks or something else?

[RobertSmith]

There are currently 24 sections and I need some simple and obvious way to implement just one or two new values for all sections. For example, if a section is Album then limit could be a minimal number of tracks per album, if a section is Artist then limit could be a minimal number of tracks per artist, and so on. So, what should be a criteria? Minimal number of tracks or minimal number of rated tracks or minimal number of played tracks or something else?

If possible, three values/scroll boxes with effect on 7 sections (calc of average rating)
1. Minimum # tracks (per artist/lyricists/composer/conductors/original artists)
2. Minimum # rated tracks per album
3. Minimum # rated tracks per genre

Or only one value: Minimum # for calculating Rating average. I believe it will be sufficient with only one value, same value for all three (5-8)?
with effect to either all 24 or only the above 7 sections

[ZvezdanD]

I suggest just one value which would be implemented differently depending of sections. If a section is Top xx Rated yy then this value would be the minimal number of rated tracks; if a section is Top xx Played yy then this value would be the minimal number of played tracks. That value would not apply to the Top xx yy With Most Tracks sections at all.

[RobertSmith]

I suggest just one value which would be implemented differently depending of sections. If a section is Top xx Rated yy then this value would be the minimal number of rated tracks

Perfect!
Top xx Rated yy is three tables where yy stands for Artist, Genre or Album with a optional minimum value of rated tracks when calculating average.

You might consider to set a max value for this "scroll box" (1 -> 10 or 12?) to avoid getting questions like "were are no rated albums in my table?"

[RobertSmith]

You might consider to set a max value for this "scroll box" (1 -> 10 or 12?) to avoid getting questions like "were are no rated albums in my table?"

Or if it's possible use minimum of the option value and total number of tracks (all tracks most be rated) for album when calc. average for Top xx Rated Album? (CDS/CDM and incomplete "junk" folders/album can be handled by MM filter)

[ZvezdanD]

There is a new update: v1.5 - 2009-07-23
- Added: option to set minimal number of rated/played tracks for Top sections.