INTERACT FORUM

Please login or register.

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

Author Topic: Group year by decade  (Read 2696 times)

lostvibrations

  • World Citizen
  • ***
  • Posts: 120
Group year by decade
« 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
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Group year by decade
« Reply #1 on: September 09, 2010, 04:39:39 am »

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

 :)
gab
Logged

lostvibrations

  • World Citizen
  • ***
  • Posts: 120
Re: Group year by decade
« Reply #2 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!
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Group year by decade
« Reply #3 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
Logged

lostvibrations

  • World Citizen
  • ***
  • Posts: 120
Re: Group year by decade
« Reply #4 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!
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Group year by decade
« Reply #5 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
Logged

lostvibrations

  • World Citizen
  • ***
  • Posts: 120
Re: Group year by decade
« Reply #6 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"?  :)
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Group year by decade
« Reply #7 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
Logged

lostvibrations

  • World Citizen
  • ***
  • Posts: 120
Re: Group year by decade
« Reply #8 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?
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Group year by decade
« Reply #9 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
Logged

lostvibrations

  • World Citizen
  • ***
  • Posts: 120
Re: Group year by decade
« Reply #10 on: September 09, 2010, 05:39:54 am »

Thanks a million!!  :D
Logged

The Mastermind

  • World Citizen
  • ***
  • Posts: 220
Re: Group year by decade
« Reply #11 on: September 09, 2010, 07:35:28 am »

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

thurston

  • World Citizen
  • ***
  • Posts: 160
Re: Group year by decade
« Reply #12 on: September 09, 2010, 10:55:26 am »

Thanks Gab and lostvibrations!  Very cool!
Logged

Gl3nn

  • Galactic Citizen
  • ****
  • Posts: 384
Re: Group year by decade
« Reply #13 on: September 09, 2010, 10:00:53 pm »

+1 and thanks from me too!
Logged
Pages: [1]   Go Up