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

Arcade Data Expressions in ArcGIS Dashboards in Portal

GISUser74305830

I've used Data Expressions in dashboards in AGO quite a bit in the past, but I'm not certain how to do so in Portal. We use Windows Authentication to login to Portal, but I can't figure out how to use the FeatureSetByPortalItem function to return the item without having to pass in credentials. I would like to just reference the Portal URL, then the item id, then have it return the feature. How do you work with data expressions in Portal?

Find more posts tagged with

Accepted answers

jcarlson

A Data Expression needs to return a FeatureSet, and that's the only thing a widget knows how to work with. I'm sure it actually does execute, but since the result is a single number, the dashboard just starts waving its hands.

Wrap the output in a FeatureSet like this:

return FeatureSet(Text({
  fields: [{name: 'the_total', type: 'esriFieldTypeInteger'}],
  geometryType: '',
  features: [{attributes:{the_total:Structure_Total}}]
}))

All comments

GISUser74305830

I'll be damned! that works!

I skipped over the whole "must return a FeatureSet". I've been able to work quite a bit with Arcade in dashboards and popups without necessarily maintaining a comprehensive understanding of Globals and all that stuff, which is why the "return a FeatureSet" didn't sear into my brain.

Thank you Josh!

jcarlson

Wrap the output in a FeatureSet like this:

return FeatureSet(Text({
  fields: [{name: 'the_total', type: 'esriFieldTypeInteger'}],
  geometryType: '',
  features: [{attributes:{the_total:Structure_Total}}]
}))

GISUser74305830

Everything is in Portal and the user has to sign in to view the dashboard. So that's nice and simple.

But the weird thing is when I test the script in the Arcade dialog it outputs the result, but when I try to use it in the indicator it says "Unable to execute Arcade script". See below.

Arcade script.txt

Unable to execute script.png

Console output.png

jcarlson

You can find a whole host of examples here: https://github.com/Esri/arcade-expressions/tree/master/dashboard_data

Using Data Expressions in Portal is the same as AGOL, except that the types of functions available to you will depend on your Portal version.

As far as credentials, that really depends on where your expression runs and where the data layer is. If you're trying to access a protected layer, you'll need to be authenticated. If your expression was running in a Dashboard in your Portal, then you probably already are, and it won't prompt you. But if the expression ran in AGOL and you were loading a Portal layer, that's when it requires authentication, and sounds like what you're experiencing.

Any reason why your dashboard and data layer are in different portals, if that is the case?

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.