Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm sure this is pretty simple but I cannot seem to get my head around it
I have a variable vCount: aggr (count ({1}race_time),race_distance, temp, altitude)
What I want to achieve is to take the race_time values that make up the aggregate and then rank them from lowest to highest. E.g:
race_time | rank |
---|---|
9.85 | 4 / 4 |
9.58 | 1 / 4 |
9.75 | 3 / 4 |
9.65 | 2 / 4 |
Any help greatly appreciated.
Thanks
Matt
Hi,
Use the Rank($(vCount))
Regards,
Kaushik Solanki
Hi,
see the attached application. Hope it will help you
try this
Rank(-1 * aggr (count ({1}race_time),race_distance, temp, altitude))
or in variable try this
Rank(-1 *$(vCount))
Thanks for the reply but I only have QV Personal so cannot view this
Apologies for not specifying this in my original post.
Thanks for the response. Rank($(vCount)) returns:
1
1
1
1
in the rank field.
If I just specify the variable it displays the correct count so I'm not sure why I'm seeing these results.
Thanks for the response. As with the previous poster these both return:
1
1
1
1
in the rank field.
If I just specify the variable it displays the correct count so I'm not sure why I'm seeing these results.
Simply give a '-' in front of the variable, vCount: -aggr (count ({1}race_time),race_distance, temp, altitude)
Then use Rank($(vCount))
rank(aggr (count ({1}race_time),race_distance, temp, altitude))
hope this helps