topic Re: Missing "Globals" in my data expression editor in ArcGIS Dashboards Questions

Missing "Globals" in my data expression editor

dstrigl — Thu, 26 Aug 2021 14:46:26 GMT

It looks like that inside the data expression editor of my sample ArcGIS Dashboard the "Globals" are missing

(as described in this video: https://www.youtube.com/watch?v=Dub1Ako2ljw&t=1008s😞

Is there any setting or somethings else to get it?

Thanks and regards,

Daniel.

Re: Missing "Globals" in my data expression editor

Anonymous User — Tue, 07 Sep 2021 17:30:08 GMT

Globals are not available in Data Expression. You have to use FeatureSetbyPortal. I'm struggling with data expressions myself.

https://www.esri.com/arcgis-blog/products/ops-dashboard/announcements/introducing-data-expressions-in-arcgis-dashboards/

Re: Missing "Globals" in my data expression editor

dstrigl — Wed, 08 Sep 2021 11:21:43 GMT

Thanks for the info and the link!

I found the way of using FeatureSetbyPortal which works fine, but this means that's not possible to directly access the features of a allready included map of the dashboard.

I have to access it using FeatureSetbyPortal. It's ok for me, but doesn't really make sense for me why it's not possible to reference it using globals vars.

Another question: Have you ever created FeatureSets using data expression with domains?

I have the problem, that if I create a new FeatureSet with the data expressions from a FeatureSet which allready have a relation to a domain this git lost 😞 ...

Regards,

Daniel.

Re: Missing "Globals" in my data expression editor

Anonymous User — Wed, 08 Sep 2021 13:18:12 GMT

I'm a novice when it comes to data expressions and arcade expressions. Slowly improving! My latest post is linked below, so hopefully my script can help you build yours!

https://community.esri.com/t5/arcgis-dashboards-questions/data-expression-for-pie-chart-in-dashboard-fails/m-p/1096039#M5033

@XanderBakker is an excellent resource for Arcade and Data Expressions. I'd highly recommend reviewing his posts and answers for more tips!

Re: Missing "Globals" in my data expression editor

dstrigl — Wed, 08 Sep 2021 13:27:39 GMT

Thanks a lot @Anonymous User

Re: Missing "Globals" in my data expression editor

XanderBakker — Wed, 08 Sep 2021 15:30:12 GMT

Hi @dstrigl ,

Just a little note; since you create a FeatureSet you could include the domain definition in the creation process. However, it might be easier to create the field with the domain description rather than the domain code for visualization purposes.

Re: Missing "Globals" in my data expression editor

dstrigl — Thu, 09 Sep 2021 07:09:14 GMT

Hi @XanderBakker,

thanks a lot for your hints!

> However, it might be easier to create the field with the domain description rather than the domain code for visualization purposes.

That's exactly what I am trying now ... something like that (using the function DomainName):

Is that the way you recommend, because it doesn't seem to work in my sample ...

But there is one additionally thing I found out. If I try the following:

var fs = FeatureSetByPortalItem(...); Console("ACCOUNT_MANAGER:"); for (var f in fs) { var d = DomainName(f, "ACCOUNT_MANAGER"); Console(d); }

I only get the numeric values and NOT the names represented by the domain!

ACCOUNT_MANAGER: 4 2 2 4 4 . . .

You have any idea why I didn't get the correct domain names?

The names are still in the layer, because if I open the table inside the Map Viewer I will see it ...

Some note: Could it be a problem that the table which includes the ACCOUNT_MANAGER has a subtype?

Regards,

Daniel.

Re: Missing "Globals" in my data expression editor

XanderBakker — Fri, 10 Sep 2021 22:35:34 GMT

Hi @dstrigl ,

I think this is caused by GroupBy function which will take the values of the account managers and not the descriptions. There are different ways to resolve this, but below you can see how you can create an intermediate dictionary and harvest the values that you need and write the result after this.

Re: Missing "Globals" in my data expression editor

dstrigl — Mon, 13 Sep 2021 06:45:59 GMT

Hi @XanderBakker,

thanks again for this well explained hint, but I think the problem why I didn't get the domain names are rooted in the base feature set I optain with the FeatureSetByPortalItem() function.

If I run the following script I still also doesn't get any domain names, although if I open the corresponding feature layer in the Map Viewer, the domain names are shown.

var portal = Portal('https://www.arcgis.com'); var itemId = '???'; var layerId = 1; var fs = Filter( FeatureSetByPortalItem(portal, itemId, layerId, ['ACCOUNT_MANAGER', 'REGION'], false), 'ACCOUNT_MANAGER > 0' ); for (var f in fs) { Console(f); var accman = DomainName(f, 'ACCOUNT_MANAGER'); Console("DomainName: " + accman); Console(""); }

Messages:

Use Console Function to output messages. {"geometry":null,"attributes":{"OBJECTID":721,"REGION":12345,"ACCOUNT_MANAGER":4}} DomainName: 4 {"geometry":null,"attributes":{"OBJECTID":722,"REGION":12589,"ACCOUNT_MANAGER":2}} DomainName: 2 {"geometry":null,"attributes":{"OBJECTID":723,"REGION":54216,"ACCOUNT_MANAGER":2}} DomainName: 2 ...

Any idea why the domain names are not part of the feature set optained by the FeatureSetByPortalItem() function?

Regards,

Daniel.

Re: Missing "Globals" in my data expression editor

XanderBakker — Mon, 13 Sep 2021 19:45:10 GMT

Hi @dstrigl ,

I think it is not the FeatureSetByPortalItem() function that is doing this. I just did a small test (in a pop-up, not in a data expression) with this function and I have access to the domain after reading the featureset with the FeatureSetByPortalItem() function.

So, could I wonder what is the data source of the data? Are you working with ArcGIS Online or with Enterprise (and if it is Enterprise, what version)? When you include the expression in a pop-up do you have access to the domain? I will do a small check within a Dashboard because maybe it is something related to the way Arcade has been implemented in the Dashboards.

Re: Missing "Globals" in my data expression editor

XanderBakker — Mon, 13 Sep 2021 19:53:27 GMT

Hi @dstrigl

I really think this has something to do with the data. Just did a small test with a data expression in the Dashboard and it can find the domain (in my data the code and description are the same values, but the domain can be accessed after reading the featureset using FeatureSetByPortalItem():

Re: Missing "Globals" in my data expression editor

dstrigl — Tue, 14 Sep 2021 14:23:05 GMT

Hi @XanderBakker,

thanks again for your help. You are right, it must be the data itself which causes the problems!

I am currently working with ArcGIS Online.

Now I created a complete new Feature Layer with a Feature Class including some domains with ArcGIS Pro.

I added some sample data and published it to ArcGIS Online.

And with this data the request of the domain names inside a data expression works!

Do you have any idea what causes the problem with the other data?

Regards,

Daniel.

Re: Missing "Globals" in my data expression editor

XanderBakker — Tue, 14 Sep 2021 23:10:38 GMT

Hi @dstrigl ,

I have no idea how the data was published and from what format, but I am glad that the test you performed shows that it does work (for the test dataset). This confirms that the issue is data-related. I would recommend you to reach out to support and create a case to discover the reason why this is not working. The fact that you are using ArcGIS Online helps since you automatically always have access to the latest version.

Re: Missing "Globals" in my data expression editor

dstrigl — Wed, 15 Sep 2021 06:08:31 GMT

Hi @XanderBakker,

thanks again.

> I would recommend you to reach out to support and create a case to discover the reason why this is not working.

That's the way I will follow.

Thanks in the meantime and regards,

Daniel.