Hi Paul,
I manged to get it working by using your example as a basis, thanks a lot. I made the following computed field and it works a treat now.
I have to say the charting feature is an awesome thing, long needed..
var result ="<script language=\JavaScript\" type=\"text/javascript\">";
result +="var series=new Array();"
exerciseview=database.getView("weightAscending");
exerciseview.refresh();
doc=tabledata.getDocument();
athleteName=doc.getItemValueString("athlete");
var vec:NotesViewEntryCollection=exerciseview.getAllEntriesByKey(athleteName);
var entry:NotesViewEntry = vec.getFirstEntry();
while (entry != null) {
doc=entry.getDocument()
weightvalue=doc.getItemValueDouble("weight");
result +="series.push(" + weightvalue + ");"
var tmpentry:NotesViewEntry = vec.getNextEntry(entry);
entry.recycle();
entry = tmpentry;
}
result +="</script>";
return result