topic Re: Where is CALCULATE? (not visible in my WebMap) in ArcGIS Online Questions

Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Wed, 17 May 2017 20:12:37 GMT

I know I am missing something obvious so forgive me.

I opened my table (Web Map).

I select some records.

I left click on column name.

I can't see CALCULATE but I do I see Sort Ascending & Sort Descending.

I have a Hosted FeatureLayer

I am the owner of the data

I am also the administrator.

I can edit features using the EDIT button and in Collector.

Where is that CALC button, am I looking in the wrong spot?

I want to do a mass calc. (Bonus Question: Can someone confirm I can select multiple features form the table but I can only select one feature at a time on the map?

Thanks for reading

Shawn

Re: Where is CALCULATE? (not visible in my WebMap)

JayantaPoddar — Wed, 17 May 2017 20:39:29 GMT

If you are the owner of a hosted feature layer, or an administrator of your organization, you can add, delete, and calculate fields on hosted feature layers.

Work with fields—ArcGIS Online Help | ArcGIS

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Wed, 17 May 2017 22:08:50 GMT

Thank you for replying Jayanta. That is why I am puzzled I am the owner and also adminstrator. Can you confirm where this CALCULATE function resides? I may be looking in the wrong spot....

Thanks for helping...

Re: Where is CALCULATE? (not visible in my WebMap)

JayantaPoddar — Thu, 18 May 2017 04:57:14 GMT

1. Follow the steps to show a table.
2. Click the column containing the field whose values you want to calculate.
3. Click Calculate.
The Expression Builder dialog box appears.
Could you provide further details about the hosted feature layer (how you added the hosted feature layer), with screenshot of the page with attribute table and its options.

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Thu, 18 May 2017 14:46:11 GMT

Thanks Jayanta,

"Could you provide further details about the hosted feature layer"

Added a layer from filegoedatabase (or geodatabase) no records, just schema to ArcMap.

In ArcMap logged in with my AGOL login

Did SHARE to hosted featureservice. It was then pushed to the cloud

Works with Collector, etc.

OPTIONS in upper right of table says:

Show Selected records

Clear Selection

Show/Hide Columns

Open table (click on TABLE icon under the featurelayer)

I left click on column name.

I can't see CALCULATE but I do I see Sort Ascending & Sort Descending.

Re: Where is CALCULATE? (not visible in my WebMap)

KellyGerrow — Mon, 22 May 2017 22:29:02 GMT

Hi Shawn,

Is this a feature layer view or a primary hosted feature layer? It isn't possible to calculate features in a hosted feature layer view or feature layers with a related tile layer:

Work with fields—ArcGIS Online Help | ArcGIS

If the layer doesn't meet any of these needs, I suggest contacting technical support to look into the specific issue.

-Kelly

Re: Where is CALCULATE? (not visible in my WebMap)

CarmelConnolly — Wed, 24 May 2017 16:00:16 GMT

Hi Shawn,

Is there a little padlock showing beside the column names in the table? Try opening the layer in a new web map to see if calculate appears.

Carmel

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Wed, 24 May 2017 16:45:30 GMT

Kelly,

Thanks for replying and sorry for the late reply.

"Is this a feature layer view or a primary hosted feature layer?"

I believe it qualifies as a "primary". I added a layer from my geodatabase to an mxd and then published it as a HostedFeatureService.

I am the owner of the data

I am also the administrator.

I can edit the features using the EDIT button and in Collector.

Thanks so much for replying...

Re: Where is CALCULATE? (not visible in my WebMap)

KellyGerrow — Wed, 24 May 2017 16:48:01 GMT

Can you post a screenshot of the entire Overview tab on the feature layer details page?

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Wed, 24 May 2017 17:08:08 GMT

Thanks for the reply Carmel. There is no padlock and when I bring into a new WebMap there is still no CALC.

(I see Ascending, Descending and Statistics)

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Wed, 24 May 2017 18:30:52 GMT

Sure thing. (Thanks for looking...)

Top Half

Bottom half

Re: Where is CALCULATE? (not visible in my WebMap)

KellyGerrow — Wed, 24 May 2017 19:49:43 GMT

Thanks Shawn,

This is quite the puzzle. Can you open the layer with full editing capabilities in the web map? It will be an option that appears when you select open in map viewer.

If you still don't see the calculate button, can you post a screenshot of the field you are trying to calculate?

-Kelly

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Wed, 24 May 2017 20:48:24 GMT

Good job Kelly. You got it to CALC doing:

"Can you open the layer with full editing capabilities in the web map?"

I am wondering if that is something I can set in the WebMap being used with Collector so I don't need to add it to a new WebMap every time I need to CALC. (That way users can just open up the WebMap and not have to deal with adding the featurelayer in a new web-map if they want to CALC. I will look at that, you have gone above and beyond. Many thanks.

Re: Where is CALCULATE? (not visible in my WebMap)

KellyGerrow — Thu, 25 May 2017 02:45:14 GMT

Hey Shawn,

Something still doesn't seem quite right. Opening the layer with full editing capabilities will give some additional editing privileges, but i'm wondering why you can't calculate the fields without the editing fields enabled. Can you share what the editing settings are on the feature service on the settings tab. Are you able to update, add and delete records or add only?

-Kelly

Re: Where is CALCULATE? (not visible in my WebMap)

CarmelConnolly — Thu, 25 May 2017 09:01:42 GMT

That's quite strange!

Would you be able to share the feature service with us? You can invite cconnolly_gov to a group if the service needs to remain private.

How was the service created in the first place?

What is the field type you're trying to calculate? You cannot calculate on the FID field.

Carmel

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Thu, 25 May 2017 15:21:29 GMT

Kelly,

It is weird. I went to a colleagues agol and she had a hosted feature service and couldn't CALC either (until we opened it with full editing capabilities.

"Are you able to update, add and delete records or add only?"

I can ADD, UPDATE,DELETE with no problem.

Thanks again for looking at this.

Re: Where is CALCULATE? (not visible in my WebMap)

MikeMinami — Fri, 26 May 2017 17:30:13 GMT

Shawn,

Is editing disabled on the layer in the map viewer?

You also said you are able to calculate when you add to new map with "Full editing control". If you simply add the layer to a new map, can you calculate?

Mike

Re: Where is CALCULATE? (not visible in my WebMap)

ShawnCarson — Sun, 28 May 2017 19:16:49 GMT

Hey Mike,

Editing is Not disabled. (I can add, edit and delete records)

" If you simply add the layer to a new map, can you calculate?"

Nope. The only way I can CALC is adding FeatLayer to a new WebMap and using Full Editing Control.

This is AGOL not Portal does that make a difference?

Thanks for the reply.

Re: Where is CALCULATE? (not visible in my WebMap)

MikeMinami — Wed, 31 May 2017 17:18:23 GMT

Shawn,

I can't figure out why this is happening. Is this a general problem across your hosted layers or just with this specific layer? We would need to look at the layer to figure out what is going on. We can open a tech support case and take this offline.

Mike

Re: Where is CALCULATE? (not visible in my WebMap)

MorganC — Wed, 13 Jul 2022 21:02:32 GMT

Okay I am having the same issue (5 years later). I also feel like I am missing something simple.

A colleague had a hosted feature layer on their AGOL, and I was using this feature no issue. Until I went to calculate a field in Map Viewer Classic. Left clicking on the field in table view only shows Sort Ascending or Sort Descending. (The field is double). There is not a padlock on this field.

Going to "Detailed View" of the field in the feature layer overview only shows a summary of the data, and it does not show "Calculate".

Thinking it was a permission issue, I made a copy of the feature layer to my own AGOL, but still nothing. I cannot figure out what I am missing.