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

Getting an error on selecting a column in data expression (Arcade)

jonasvanduijvenbode

So I have a dataset that contains a column with dates. I want to create a pie-chart that shows the amount of cells in that column that is empty and the amount that has a value. So I tried to create a data expression. In this data expression I filled in:

var feat=FeatureSetByPortalItem(Portal('correctaddress'), '6227a7a523744c978d8fb6280168c119', 0)
return IsEmpty(feat.VerwijderdOp)

Of course the 'correctaddress' is normally filled with the actual link to my organisation. If I just do return(feat) I can see the entire table, which has a column called VerwijderdOp. However, when I try this or even try to access any column, so even something as simple as return feat.OBJECTID, I get the error

Execution Error:Runtime Error: Cannot call member property on object of this type. VerwijderdOp

Can anybody help me out?

Find more posts tagged with

Arcade

Accepted answers

DavidPike

There's maybe a much better way of doing it, but I just calculated the total null dates as a variable, the total not null dates as a variable (total count - count null), then created a new feature set containing those values.

I've added your time field as features.verwij... (Line 😎 but I may have spelt it wrong, other than that the only thing you should add is the portal item ID (Line 2).

For the pie chart widget, In 'Data Options' I would probably choose 'Categories from - 'Fields' -> add both Total Null and TotalNotNull fields, and use a statistic of 'Sum'.

var portal = Portal('https://www.arcgis.com')
var features = FeatureSetByPortalItem(portal, 'InsertYourItemIDHere')

var featCount = Count(features)

var nullCount = 0
for (var feature in features) {
    if (IsEmpty(feature.VerwijderdOp)) {
        nullCount += 1
    };
}

var notNullCount = featCount - nullCount

var featureDict = {
    'fields': [{'name':'TotalNull', 'type':'esriFieldTypeDouble'},{'name':'TotalNotNull', 'type':'esriFieldTypeDouble'}
        ],
    'geometryType':'',
    'features':

[
  { 
    "attributes" : {
      "TotalNull" : nullCount,
      "TotalNotNull" : notNullCount,

    }
  },

]}
     
return FeatureSet(Text(featureDict));

All comments

jonasvanduijvenbode

Hi David,

very impressive, thank you so much for this answer! So also if I understand correctly I cannot apply a function on an array but I can apply it item-wise, which is naturally done in a pop-up but requires a for-loop in a data expression. This makes sense and again thank you for the solution.

DavidPike

I've added your time field as features.verwij... (Line 😎 but I may have spelt it wrong, other than that the only thing you should add is the portal item ID (Line 2).

For the pie chart widget, In 'Data Options' I would probably choose 'Categories from - 'Fields' -> add both Total Null and TotalNotNull fields, and use a statistic of 'Sum'.

var portal = Portal('https://www.arcgis.com')
var features = FeatureSetByPortalItem(portal, 'InsertYourItemIDHere')

var featCount = Count(features)

var nullCount = 0
for (var feature in features) {
    if (IsEmpty(feature.VerwijderdOp)) {
        nullCount += 1
    };
}

var notNullCount = featCount - nullCount

var featureDict = {
    'fields': [{'name':'TotalNull', 'type':'esriFieldTypeDouble'},{'name':'TotalNotNull', 'type':'esriFieldTypeDouble'}
        ],
    'geometryType':'',
    'features':

[
  { 
    "attributes" : {
      "TotalNull" : nullCount,
      "TotalNotNull" : notNullCount,

    }
  },

]}
     
return FeatureSet(Text(featureDict));

jonasvanduijvenbode

Hi David,

thanks for your reply. I am indeed trying to use a column in my feature set as an argument, so any help with that would be great.

Your solution (Null/Not Null) is not possible since the column that I want to use 'called verwijderdop' is a date column which you cannot use in a pie chart.

The link that you provided would work for pop-ups etc but not for what I am trying to do here.

DavidPike

I'd say IsEmpty() is a logical check against a field value, and you're attempting to input a feature set as an argument.

What do you actually want to do? Can you not just return your feature set and then use that as the input for the pie chart (classified by Null / Not Null?).

Or use the Count and Filter methods together - described here - Calculating feature count of attribute type using arcade in ArcGIS Online - Geographic Information Systems Stack Exchange

Join the Conversation

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

Quick Links

All Communities
Recent Posts
Followed Content
Community Help

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