nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculating a field using Orderby

Azita

Hello!

GIS newbie here looking for help with an Arcade expression.

I have a field named BeginTime with content such as "2024-06-20T11:36:31-07:00, 2024-06-20T11:36:16-07:00." I'm honestly not sure what the 07:00 is about but the orange timestamp is what I'm looking to use to number my field, "TPE." I want TPE to list the features/points as integers in order of time collected.

I'm not sure what it means by "wrong number of arguments."

Screenshot 2024-08-01 165852.png

Thanks!

Azita

Find more posts tagged with

Analysis

Desktop

Accepted answers

jcarlson

OrderBy takes two arguments, a FeatureSet and a SQL expression used to sort the features.

You can definitely still use Arcade for this, but it's probably not going to work very well. In a field calculation, the expression will have to evaluate for every feature separately, but since the value you want is dependent up on each feature's relation with every other feature, well, that expression could take a long time to run.

This wouldn't be terrible in Python, perhaps, but you're almost better off exporting to a spreadsheet, sorting the sheet and adding an auto-increment value there, then joining the sheet back into your layer based on the objectid. Then you could just refer to the joined field in your field calculation.

All comments

vsogekr9

@vsogekr9 wrote:
Ah legend, it works! I'm not too sure why though, still very new to SQL. Could you explain what left outer and join does?
And ya the 'Likes has no default value' is weird. I think it could be because the column heading isn't the name of the column or something like that but not too sure https://omegle.onl/ .

I got this,...

vsogekr9

Ah legend, it works! I'm not too sure why though, still very new to SQL. Could you explain what left outer and join does?

And ya the 'Likes has no default value' is weird. I think it could be because the column heading isn't the name of the column or something like that but not too sure.

jcarlson

OrderBy takes two arguments, a FeatureSet and a SQL expression used to sort the features.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.