Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[mark_h]

I've been collecting pop chart hits for a couple of years and want to create a view that allows me to view songs by year and month as well as chart position but I'm wondering about the best way to store the data or if it's even possible.

What I'm wondering is, if I create a semicolon delimited list field, eg chartpos, which looks something like this

chartpos: 19681125:1; 19681201:8; etc

eg the song entered the charts on 25 November 1968 at position 1, before slipping to position 8 the following week, would it be possible to create a view using that data where I could drill down to 1968, month 11 and see the chart entry BUT ALSO 1968 month 12 and see the next chart entry?

[mark_h]

An customise view expression field:

Code: [Select]

Listbuild(1,\,left([chart date],4),mid([chart date],4,2))&datatype=[list]
Is a start, but it's not splitting the chart date field into separate entries.  Work continues...

[mark_h]

OK, if I use a data format:

1952\12\27

I start to get the subfields I need...  simply becuase of the\ in the data...

[mark_h]

Well, unless there are better ideas, the above seems to be the solution for now.  It is not without shortcomings.  Even though MC will display the following tree, for this [chart history] data 1952\12\23\9, simply using the expression

Code: [Select]

[chart history]&datatype=[list]
1952
__12
____23
______9

It seems you cannot apply processing to each of the children nodes... only the string as a whole, which means some things I want to do aren't possible, eg work with my original data strings that dont have the \ in them... so I have to massage my entire data set to work with the MC scheme.  Doable, but not ideal.

Still, impressive what can be achieved in MC.

[mark_h]

Falls at last hurdle 

I created the field Chart History and populated it with data of the format:

year\month\day\position;

eg

1952\11\15\1; 1952\11\22\3;

This can be displayed correctly as a drillable tree, but because MC only parses the start of the data entry, eg 1952\11\15\1 in the above, I cannot sort the display on the position number, so I drill down to a week, month, year and can display all the tracks that were in the charts that week but I cannot sort their order correctly.

Any ideas?

Cheers,

Mark