Top 10 List

[haironfire]

Basic question. Have a list of taxlot acreages for many cities and counties. Want the top 10 records sorted descending order for all jurisdictions. Can't figure out how to start this. Help.

[JennyAnders]

You haven't said what you want them sorted descending by. Descending order by property value? Descending order by acreage? Descending order by zip code?

Once you figure that out the rest is easy. First sort, selecting the file that matches what you want the the descending order by, once it is in the list at the right, select it and then choose the 'descending' option at the bottom of the dialog.

Then set yourself up a script that goes like this

show all records

sort

omit multiple (set for ten records, without dialog)

show omitted

The sort order that you created before the script gets saved with the script, so every time you run the script it will give you the top ten.

[Camden]

Yea cool Jenny

You could also do a self-join relationship with a constant calculation ( calc = 1 ) matched to itself, set the relationship up with the descending sort on whatever, and put a portal on yer layout with ten rows.

Portal will always show the current top ten.

[haironfire]

Thanks for the tips. A script, huh? OK, looks pretty easy, but it is new territory to me. BTW, I am sorting by daily vehicle trips.

[haironfire]

This looks more like what I had in mind. So, if I read this right, the descending sort is defined as part of the relationship? Hmm..never tried that before. Thanks for the help.

[haironfire]

Well, I guess I need to learn more about portlals. Right now, it just shows 10 versions of the same record.

[Vaughan]

Off topic: you don't know how groovy it is seeing Americans posting images of Australian actors! Can't wait for Matrix 2.

For those who like Hugo Weaving (aka Agent Smith) and want to see more, go see "Priscilla, Queen of the Desert."

[Vaughan]

Ooops forgot to answer you're question...

If you're getting the same value repeating in your portal it could mean:

1) each related record really does have the same value.

2) the field in the portal isn't through the same relationship as the portal.

I'd say the problem is 2. You probably have a "local file" field in the portal.