topic Re: How do I create a permanent field calculation in an AGOL feature layer? in ArcGIS Online Questions

How do I create a permanent field calculation in an AGOL feature layer?

AshleyThornton — Fri, 21 Feb 2020 17:15:18 GMT

I have create a map to use in Collector for ArcGIS for the fire department. After using it they have a request: Once they input values for Field A and Field B, they want Field C to calculate a solution using Fields A and B.

I have used the calculate field function in AGOL (ex. Field C = Field A + Field B). However, the field will not 'remember' this calculation. I want the field calculation to stay in that field so that each time I or another user opens the map and inputs the data for A and B, it will auto-populate the value for C. Is there a way to NOT have to run a field calculation each time I open the map?

Re: How do I create a permanent field calculation in an AGOL feature layer?

JacobWatson1 — Tue, 10 Mar 2020 21:21:11 GMT

If your data is being hosted as a Feature Layer, you should be able to add a field and perform calculation on it.

If you go to your Feature Layer -> Data -> Context Menu on the top right of the data -> Add Field -> Click on the new fields header -> Field Calculator.

You should be able to populate the new field with the data you want with this method.

Here is a picture of what it looks like when you have the Context Menu open.

I hope this helps!

- Jacob Watson

Re: How do I create a permanent field calculation in an AGOL feature layer?

glennhazelton2 — Thu, 02 Apr 2020 18:53:18 GMT

if you want the values to be calculated as data is entered then you need to create an expression in field. using the calc tool will only work manually. what i have done is create a field and then in the mapviewer create an expression. this can be a combination of other fields. below is what one looks like that i built to do labeling- it does concatenation and rounding.

"Ave. Salinity: "+Round(Average($feature["Salinity_1"],$feature["Salinity_2"],$feature["Salinity_3"]),0)

Re: How do I create a permanent field calculation in an AGOL feature layer?

SayenaFarid_Marandi — Mon, 08 Jun 2020 17:40:02 GMT

Hi Glenn,

Where did you create an expression ? in Pop-up? then we cannot populate any field . Is there any way that we can have an expression to update a field "C" every time we change fields "A" and "B"?

Re: How do I create a permanent field calculation in an AGOL feature layer?

SallyGalewski — Fri, 19 Jun 2020 15:10:47 GMT

I also have this question. Very similar situation except my calculation is done on a related table for a hydrant feature and not the hydrant feature itself.

(Field A \ Field B) *200 = Field C. Depending on the results of the calculation, I want the text to change to red, if the test needs to be redone.

Re: How do I create a permanent field calculation in an AGOL feature layer?

AnuSawant — Wed, 29 Jul 2020 19:01:53 GMT

Any workaround for this? I also have the same question.

Re: How do I create a permanent field calculation in an AGOL feature layer?

AnuSawant — Wed, 29 Jul 2020 19:04:01 GMT

Can you please explain where to add this expression? In my case feature service has got Sync and editor tracking enabled so I can't use the Arcade expression. And as mentioned by other SQL or other calculations are just once off.

Thanks,

Anu

Re: How do I create a permanent field calculation in an AGOL feature layer?

SallyGalewski — Wed, 29 Jul 2020 19:36:55 GMT

Hi Anu,

When in AGOL, I clicked on my related table and went to the “Attribute Expressions” and clicked “Add”. I added my expression:

Return ($feature.RLUcATP / $feature.RLUATP1) * 200 Clicked “Test” and it looked like this:

This video shows how to do it. (about the 4 minute mark)

https://www.bing.com/videos/search?q=using+html+formatting+in+a+pop-up+using+arcade&&view=detail&mid=310D06E17F05BD516F90310D06E17F05BD516F90&&FORM=VRDGAR&ru=%2Fvideos%2Fsearch%3Fq%3Dusing%2Bhtml%2Bformatting%2Bin%2Ba%2Bpop-up%2Busing%2Barcade%26%26FORM%3DVDVVXX

Hope it helps!

Sally

Re: How do I create a permanent field calculation in an AGOL feature layer?

AnuSawant — Wed, 29 Jul 2020 21:04:06 GMT

Thanks Sally.

Re: How do I create a permanent field calculation in an AGOL feature layer?

CVHCMaster — Wed, 08 Sep 2021 16:43:43 GMT

Hi Sally,
It seems that “Attribute Expressions” created this way on maps cannot be used/referenced in dashboard displays. So I would not be able to pick "ATP Calc" or {expression/expr0} when I make a dashboard indicator or list.
Or am I missing how to use/reference them in dashboard displays?
Any help would be appreciated!

Re: How do I create a permanent field calculation in an AGOL feature layer?

JoshSender2 — Fri, 24 Sep 2021 13:51:46 GMT

It seems like we should be able to accomplish this - making a calculated column usable in a dashboard indicator or list - by writing an advanced formatting arcade expression. For the life of me though, I cannot seem to figure it out the correct code. In my head, here's the way it would work

Define a feature set from the existing item (FeatureSetByPortalItem)
Define a new feature set by defining a dictionary which has all the same fields as the original feature set plus the additional yet to be calculated field
Write a for loop that would iterate over the number of features in the original feature set and would assign attribute values to the new feature set - with the values of the not-calculated fields simply being equal to the i(th) [the iteration number] value in the original feature set of the corresponding original attribute, and the calculated column references some combination of the original feature set i(th) attribute values.
Return the new feature set and make a list or indicator from the new values.

Great in theory, but I cannot seem to make it actually work. This sort of thing is super simple in Power BI - making a calculated column. But all of the Googling and trying I've done so far say it's either difficult or impossible in ArcGIS Dashboards.

I'm happy to share my nonfunctioning code if anyone thinks they can actually make this work.

Re: How do I create a permanent field calculation in an AGOL feature layer?

davidlam123 — Wed, 06 Oct 2021 08:34:05 GMT

Hi, I am also struggling for this question and haven't figured out a solution to fix it. dashboard doesn't inherit AGOL expression. it doesn't add to the feature layer itself, but only the pop-up. is there any way to fix this issue. I have a lot of calculated field in attribute table. I need the attribute table to automatically calculate and remember the calculated field when i append new row of data. Eventually, the information is captured automatically in dashboard configured list of element

Re: How do I create a permanent field calculation in an AGOL feature layer?

Kantoor__DataCount_-_Verkeerso — Mon, 11 Oct 2021 15:25:40 GMT

Same problem here..

Re: How do I create a permanent field calculation in an AGOL feature layer?

MattTarkington1 — Fri, 31 Dec 2021 00:58:25 GMT

I too have been struggling with this for quite a while and have found a bit of a solution! (if you have access to ArcPro).

I pull my feature layer out of the portal into ArcPro and put the Calculate Field into a Model scheduled to run periodically.

Only downside I see to this is that the machine with the Scheduled Tool has to be on in order for this to work. As I understand it, ArcPro doesn't even have to be open.

Hope this helps!

Re: How do I create a permanent field calculation in an AGOL feature layer?

JoshSender2 — Fri, 07 Jan 2022 22:51:22 GMT

I just tested this out on some scrap data and this works brilliantly. It is in no way shape or form the ideal solution to this issue, but hey, any solution is better than no solution.

Thanks for sharing!

Re: How do I create a permanent field calculation in an AGOL feature layer?

DavidForbuss1 — Wed, 20 Apr 2022 21:54:52 GMT

This worked! Thanks @SallyGalewski ! Can't wait to implement this in some of my maps. The only thing I noticed that didn't seem to work was labeling off of this expression field. That'd be a nice addition so the field crews see the calc'd value right away.

Re: How do I create a permanent field calculation in an AGOL feature layer?

timshapiro — Mon, 27 Mar 2023 22:00:56 GMT

would it be possible to do this using Notebooks?

Re: How do I create a permanent field calculation in an AGOL feature layer?

MattTarkington1 — Mon, 08 May 2023 22:56:44 GMT

I believe so. It's something that I'm experimenting now. Having issue's with the arcpy.management CalculateField module though.

Re: How do I create a permanent field calculation in an AGOL feature layer?

DavidForbuss1 — Thu, 01 Jun 2023 18:28:09 GMT

I use an acrade script to create a popup that calcs two dates against each other. Seems like you could do the same for other fields. I got this template from a forum on here (sorry, I forgot where or I'd give them credit). Anyway, here's mine. Must be used in the new map viewer, so add this as one of your expressions, then in the popup add {expr/1} or whatever number it is:

// Access 'Inspections' table as a FeatureSet
var portal = Portal("PORTAL ADDRESS HERE")
var inspections = FeatureSetByPortalItem(portal,
"ITEM NUMBER HERE", <layer # in service here>, ['field1', 'field2',
'field3'])

// Filter related features by using a common attribute
var facilityid = $feature.parentID
var filterStatement = 'childID = @parentID'

// Related features as a variable
var relatedData = Filter(inspections, filterStatement)

// Sort related features by oldest to newest
var relatedDataSorted = Top(OrderBy(relatedData, 'field3 DESC'),1)

// Build the pop-up string by iterating through all related features
var popupString = 'Last Flushed Date: '
for (var f in relatedDataSorted){

popupString += Text(f.field3, 'MM/DD/YYYY')

}

DefaultValue(popupString, 'No measurements to show')

Re: How do I create a permanent field calculation in an AGOL feature layer?

MattTarkington1 — Mon, 05 Jun 2023 18:13:27 GMT

I have been able to get this to work in notebooks. It runs faster than in a model builder. And you have access to more Python modules.