INTERACT FORUM

Please login or register.

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

Author Topic: Getting Statistical Information with help of Expressions  (Read 1412 times)

StiX

  • Regular Member
  • Recent member
  • *
  • Posts: 23
  • i really have nothing more to say...
Getting Statistical Information with help of Expressions
« on: April 21, 2005, 08:07:34 pm »

It would be very useful to have a Function, which could gather Quantity of Database Entries with Same Value of Specified Field.
I think it should not be a problem to add such a function, as MC already can show Statistical information in Action Window > File Properties > Statistics > Artist / Album. While it's a little bit useless there, such a functionality will be useful as a function.

Now, how it should work and what parameters it should have? My proposals about naming the function: DataEntries(), FieldInstances(), TotalFieldEntries(). Something like that.

There should be only one parameter: a [Field] or some Keyword.

Example of resulting functionality.
Let's say we want to see a View with following information
      [Album] : TOTAL_TRACKS_OF_CURRENT_TRACK_ALBUM
We would create an expression
      [Album] : DataEntries([Album])

Another example:
      [Genre] : DataEntries([Genre])
Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: Getting Statistical Information with help of Expressions
« Reply #1 on: April 22, 2005, 02:21:32 am »

OK, how would you make a data expression that displays totals by field (in this example genre)  in a column of a viewscheme, using the above.

The result should show

Genre 1 (total albums)
Genre 2 (      "            )
.
.
Genre n (    "              )

Note we are in effect programming the output of one column of a viewscheme here.
Logged

StiX

  • Regular Member
  • Recent member
  • *
  • Posts: 23
  • i really have nothing more to say...
Re: Getting Statistical Information with help of Expressions
« Reply #2 on: April 22, 2005, 05:38:55 am »

Not really understand what are you complicating on this.

The result should show:
Code: [Select]
Genre 1 (total_files_of_this_genre)
Genre 2 (total_files_of_this_genre)
.
.
Genre n (total_files_of_this_genre)

The output of this would be useful not in Table Columns, but in "Top View Columns".
Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: Getting Statistical Information with help of Expressions
« Reply #3 on: April 22, 2005, 08:22:55 am »

Not really understand what are you complicating on this.

The result should show:
Code: [Select]
Genre 1 (total_files_of_this_genre)
Genre 2 (total_files_of_this_genre)
.
.
Genre n (total_files_of_this_genre)

The output of this would be useful not in Table Columns, but in "Top View Columns".

I am referring to the panes columns, is this the same what you mean by "Top View Columns" ?

If so...yes that is what i was looking for.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42323
  • Shoes gone again!
Re: Getting Statistical Information with help of Expressions
« Reply #4 on: April 22, 2005, 08:46:56 am »

These functions would be nice, but there are some performance implications.

When one function accesses every entry in the database instead of just the one it's working with it exponentially adds to the overhead.
Logged
Matt Ashland, JRiver Media Center

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: Getting Statistical Information with help of Expressions
« Reply #5 on: April 22, 2005, 10:02:03 am »

Ahh...was afraid you would say that.  Was trying to get away from excel for this sort of thing.

The only way i can see around this is to pre-calcualte them somehow..but it becomes messy.
Logged

StiX

  • Regular Member
  • Recent member
  • *
  • Posts: 23
  • i really have nothing more to say...
Re: Getting Statistical Information with help of Expressions
« Reply #6 on: April 22, 2005, 11:45:17 am »

I wouldn't say that there are any performance implications in the Action Window > Statistics

By selecting all files in the Library, the table in Statistics > Albums updates almost instantly...
Logged
Pages: [1]   Go Up