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; } } }

Groupby Function in Arcade

Mokwena9

I have a dataset that includes a list of countries with the different studies done in those countries, and I want to auto calculate the number of studies per country in a new field.

I have used the Arcade GroupBY function as follows: GroupBy($layer,'COUNTRY', {name:'NumberS', expression:'Title', statistic:'COUNT'})

And I get this error: Cannot insert Object in Integer field. You can review the error in the script editor and try the calculation again, or cancel this calculation without changing any data.

Screenshot 2023-08-02 152238.jpg

JenniferAcunto_7-1729105120792.png

Find more posts tagged with

Arcade

Accepted answers

kenbuja

You have a typo. It's "statistic" not "statistics"

GroupBy($layer, 'COUNTRY', { name:'NumberS', expression:'Title', statistic:'COUNT'})

All comments

kenbuja

You have a typo. It's "statistic" not "statistics"

GroupBy($layer, 'COUNTRY', { name:'NumberS', expression:'Title', statistic:'COUNT'})

Mokwena9

@KenBuja Thank you I have fixed that, but I still get an error

kenbuja

Are you getting the same error or a different one?

Mokwena9

@KenBuja I get this error: Cannot insert Object in Integer field. You can review the error in the script editor and try the calculation again, or cancel this calculation without changing any data.

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.