forum home | register | profile | members |search | faq
homepage | lost password? | chat room
|
|
QSA ToolWorks Public Feedback Forum forum home | register | profile | members |search | faq homepage | lost password? | chat room |
| QSA ToolWorks Public Feedback Forum > General Helix Talk > Helix Score Positions | You are not logged in. Login or Register. |
| Pages: 1 |
|
| Author: | Topic: Helix Score Positions | |||
afyfe Posts: 6 Registered: 2004-07-06  fyfee1970@yahoo.com  62547735 |
 Posted: Jul 06, 2004 10:08:42 am    
Wondering if anybody can help me figure this one out.. I have a list of competitors with their scores e.g. a = 100 b = 110 c = 110 d = 111 e = 110 now if I want them to list in order of ranking.. e.g. d gets 1st, b c and e share second, and 100 gets third whats the easiest way of doing it. the fields are name score at the moment I am using the <score>-usefrom-<relation> is equal or greater to <score> and then using this abac called rank. in one which has IF < DEFINED< FORM PREVIOUS<rank> > THEN IF < FORM PREVIOUS<rank> = rank > THEN < FORM PREVIOUS<rank> > ELSE < FORM PREVIOUS<rank> + 1 > ELSE <1> its so close, very close but not right. ta to ryan for his time so far on this - Edited by afyfe on: Jul 06, 2004 10:10:02 am - Edited by afyfe on: Jul 06, 2004 10:10:57 am |
|||
| Ryan Wilcox Posts: 32 Registered: 2003-04-17 |
Posted: Jul 07, 2004 1:58:13 pm
See helixnewbies.editthispage.com/stories/storyReader$65. Now, this requires that NAME be unique to work. Except in your case SCORE is not unique. However, I'm guessing you have some sort of unique identifier in that relation - competitor name, or competitor id. Let's say it's ID Construct the number just like in the above article but instead of NAME, create an abacus that does THIS: <SCORE> FOLLOWED BY < <!> FOLLOWED BY <COMPETITORID> > In the USE>NAME abacus in the example, use that newly constructed abacus instead of NAME. Also you'll need to use a >= tile instead of a <= tile. Where the view in the example is indexed on NAME, you need to instead index on SCORE. Hope this helps. I'll try to attach a sample to this post, but IIRC that's always been scary on these boards. We will see if it works. _Ryan Update: I guess it didn't make it. Email me off-board if you want a copy. - Edited by Ryan Wilcox on: Jul 07, 2004 1:59:12 pm
|
|||
| afyfe Posts: 6 Registered: 2004-07-06 fyfee1970@yahoo.com 62547735 |
Posted: Jul 12, 2004 12:55:47 pm
thanks for your input.. the problem that I have at the moment is that when I use the subtotal tile I get the number or the records order in the relation, firstly there are loads of other scores in the relation i.e. there is more than one event in the relation e.g. event 1 event 2 each has its own scores so that I don't want it to subtotal the whole of the event scores just one of them... this doesn't pose a problem to me but what does cause me problems is that some of the scores sometimes even three of the scores hold the same value so that say record 100 has a score of 130 and record 101 has a score of 120 and record 200 has a score of 120 and then record 201 has a score of 120 and then record 220 has a score of 100 - i.e. scores relevant to this event: thus we have 130, 120, 120, 120, 100 as scores.. if I use the form previous tile I get 130 as first, 120, 120, 120 as 4th and then 100 as 5th so that there are big jumps in there. I have tried using the form count and form previou+1 which works and gives me 1, 2, 2, 2, but when it comes to the 100 score it gives me 5 as a returned value which I just can't work out.. its doing me noggin in. if anybody fancies texting me on my mobile their ideas 07976835747 I would be grateful as I am currently in greece and email is not an easy thing to get hold of as I am on an island. thanks again for your help with this |
|||
| Fred Posts: 57 Registered: 2003-04-10 |
Posted: Jul 13, 2004 2:17:10 am
I have an extremely simple example that gives a solution. Can't text it but if you want it by email - even though it is difficult on an island - let me know. Fred |
|||
| afyfe Posts: 6 Registered: 2004-07-06 fyfee1970@yahoo.com 62547735 |
Posted: Aug 03, 2004 5:27:16 pm
fred tried to contact you on your email but your email server seems to bounce my mail back. no worries though. thanks for the file you sent to me with your static relation in it.. I have another need to do with scoring now.. using the formcount.. or the subcount.. either will do but I will explain whats happening and you can advise me why perhaps. When I use the [use from] tile and itsgreaterthan tile to hold the current score in memory and then formcount this abacus on a form, I get the following values for these scores.. e.g. score 100 gives 1st, score 90 gives 2nd, score 80 gives 4th, score 80 gives 4th, score 70 gives 5th. as you can see the formcount seems to give to idential scores the higher form value before it resumes. any ideas why ?? as I really wanted it to be 1st, 2nd, 3rd, 3rd, and 5th. ta again fred, and if you want to connect to my site to get a copy of the collection I am working on to see what I am on about, let me know. - its 18 meg at the moment. |
|||
| Fred Posts: 57 Registered: 2003-04-10 |
Posted: Aug 04, 2004 4:18:19 pm
quote: My Communication-unltd address ?? Try the same name @wanadoo.fr quote: Are you sure you're not using "greater than or equal to" ? Why aren't you using the static relation? send me your site details and I'll take a look (stuffit first though) - I'm on a isdn phone line ;?( cheers Fred |
| Pages: 1 |
|
| Lost Password? Powered by UPB Version : 1.8 A script by PHP Outburst |
