INTERACT FORUM

More => Old Versions => Media Center 15 (Development Ended) => Topic started by: lostvibrations on September 09, 2010, 04:13:37 am

Title: Group year by decade
Post by: lostvibrations on September 09, 2010, 04:13:37 am

I have set up a new audio tree view to group by year. At present it groups by each individual year. How can I get it to group by decade (e.g. 1970's, 1980's, etc) and when opening that, to group by year (e.g. 1971, 1972, etc)? Thanks

Title: Re: Group year by decade
Post by: gappie on September 09, 2010, 04:39:39 am

i use this as an expression: if(isempty([year]),?,mid([year],0,3)0

 :)
gab

Title: Re: Group year by decade
Post by: lostvibrations on September 09, 2010, 04:46:32 am

Thanks - I imported that into rules for file display, but when I hit OK it doesn't find any files at all!

Title: Re: Group year by decade
Post by: gappie on September 09, 2010, 04:53:24 am

im sorry.. guess that that was a bit to quick.
it should not be in the rules.
when you make a view, when using categories or panes, you can add fields you want to see, but also expressions. at the left side of the customize view window. use this expression there.

hope that is clearer, if not i make a screenshot..

 :)
gab

Title: Re: Group year by decade
Post by: lostvibrations on September 09, 2010, 04:59:55 am

Thanks gappie, that worked - the tree view now groups the music via decade. However, I want it to then have a sub-group by individual year - like this:

1970
1980
1990
---1991
---1992
---etc

Is this possible? Thanks!

Title: Re: Group year by decade
Post by: gappie on September 09, 2010, 05:04:00 am

the next step is to add a second item to the categories after the decade. pick year from the fields list.

 :)
gab

Title: Re: Group year by decade
Post by: lostvibrations on September 09, 2010, 05:07:07 am

Great! And finally, is it possible to have it show "1980's, 1990's", etc, in the list instead of "1980, 1990"?  :)

Title: Re: Group year by decade
Post by: gappie on September 09, 2010, 05:09:39 am

just change the expression: 
if(isempty([year]),?,mid([year],0,3)0
in
if(isempty([year]),?,mid([year],0,3)0's

 :)
gab

Title: Re: Group year by decade
Post by: lostvibrations on September 09, 2010, 05:18:21 am

Thanks for all your help gab  :)

One other thing; after grouping by individual year, I want the tree to show album artist - album, like this:

1980's
1990's
---1991
---1992
---1993
------Bob Dylan - Pink Flies
------Duran Duran - Yellow Smarties
etc

However if I add the expression [album artist] - [album], then the tree just shows (blank) - "date". Any idea what is going on here?

Title: Re: Group year by decade
Post by: gappie on September 09, 2010, 05:26:40 am

dont know about the date, but i guess album artist is empty, which most of the time is good.. try this instead:
[album artist (auto)] - [album]

 :)
gab

Title: Re: Group year by decade
Post by: lostvibrations on September 09, 2010, 05:39:54 am

Thanks a million!!  :D

Title: Re: Group year by decade
Post by: The Mastermind on September 09, 2010, 07:35:28 am

I'll throw my thanks in there too. That's a nice improvement in my organisation.

Title: Re: Group year by decade
Post by: thurston on September 09, 2010, 10:55:26 am

Thanks Gab and lostvibrations!  Very cool!

Title: Re: Group year by decade
Post by: Gl3nn on September 09, 2010, 10:00:53 pm

+1 and thanks from me too!