topic Re: ArcGIS Online Experience Builder Table number decimal places in ArcGIS Online Questions

ArcGIS Online Experience Builder Table number decimal places

LIEPAJABUILDINGBOARD — Thu, 30 Mar 2023 07:14:05 GMT

Hello!

I have created ExperienceBuilder app with table widget displaying field of numbers with decimal places. In the webmap I have configured decimal places up to two digits, but in the ExperienceBuilkder Table it displays many decimal places. It appears not to all othe entries but to several of them. As these are money amounts, the more than two decimal places look weird. Where should it be configured to display certain amount of decimal places? Below are examples (screenshots) showing decimal places of the same entry.

Screenshot No. 1: Experience Builder Table widget number decimal places extended

Screenshot No. 2: WebMap pop-up of the same element number field

Re: ArcGIS Online Experience Builder Table number decimal places

AndreasHall — Thu, 30 Mar 2023 11:27:54 GMT

I found a related community post where the answer is that removing thousands separator and other settings are on the road map. Hopefully the product development team pick up your request as well!

How to remove comma separator in Experience Builde... - Esri Community

There is also a bug documented: BUG-000152331: The thousand separators are not honored by the Table.. (esri.com). You could try to reach out to technical support in your country and report this as a bug.

Re: ArcGIS Online Experience Builder Table number decimal places

TomKukitz — Tue, 10 Oct 2023 15:56:40 GMT

How is this fix coming along? I have Manholes with slopes in EB looking like this: 1.02365897458295%

This is inexcusable! My Director asked me to fix this and I said I can't Esri has to fix it. He made the comment of for how much we pay for this GIS system something like this should not be an issue!

Re: ArcGIS Online Experience Builder Table number decimal places

LindsaySpencer-Henderson — Mon, 08 Jan 2024 17:11:23 GMT

Hi @AndreasHall - will this be addressed with the next update? If anyone has found a work-around, please advise, thanks!

Re: ArcGIS Online Experience Builder Table number decimal places

AndreasHall — Tue, 06 Feb 2024 07:20:33 GMT

Sorry, I do not have any insights in the development of Experience Builder. I am not on that team.

Re: ArcGIS Online Experience Builder Table number decimal places

NIC — Fri, 05 Apr 2024 00:30:22 GMT

Any updates on this issue? I'd really prefer not to have to shorten 60+ fields on a live layer.

Re: ArcGIS Online Experience Builder Table number decimal places

AndrewWelsh — Mon, 27 Jan 2025 03:07:41 GMT

Has this been issue been resolved? I am currently having the same issue as those in the chain above with multiple decimal places in the table hosted feature layer I am using in my experience app. I have not as yet found a solution to this in AGOL or Experience Builder? Any updates from ESRI would be much appreciated.

Re: ArcGIS Online Experience Builder Table number decimal places

AndrewWelsh — Mon, 27 Jan 2025 03:29:38 GMT

Update on my last message - I found if you are publishing an excel file to AGOL as a hosted feature layer for use as a table in experience builder, you can set the data type to double as you are preparing the layer for publishing. I had it on single data type initially and got heaps of decimal places turn up when I used in experience builder. But setting the type as double, the table displays exactly as I have set it up in the excel file (in this case 1 dp). Hope this helps!

Re: ArcGIS Online Experience Builder Table number decimal places

eleanor_ME — Thu, 06 Feb 2025 10:10:32 GMT

Currently dealing with the same issue. Are there any updates or workarounds on this?

Re: ArcGIS Online Experience Builder Table number decimal places

AdamsCheyenne — Mon, 24 Feb 2025 18:57:04 GMT

I am also dealing with the same issue. Unfortunately, I'm displaying data from a Chart Statistics Output View (generated in a Chart Widget in the same app) in the Table Widget, so I have no option to edit the decimal places in the source data outside of Experience Builder. It displays acreage as 5.37392027759302773674 acres which is absurd and does not look professional at all.

Re: ArcGIS Online Experience Builder Table number decimal places

JD_GIS — Wed, 19 Mar 2025 14:27:24 GMT

My recommendation is to create another field and "copy the values" to include only 2 decimal places, or at worse, copy everything into an excel sheet, then force only 2 decimal places there, re-import back into the original layer, then upload and refer to that column/field instead.

Re: ArcGIS Online Experience Builder Table number decimal places

WillAnderson — Thu, 15 May 2025 17:34:05 GMT

We are using the Round() function whenever possible, but that doesn't address this problem either.

I echo other users' frustration at the amount of "advances" we see from Esri on fringe applications (like ArcGIS Indoors), but continue to see a persistent lack of addressing basic functionality like this issue, particularly when we are forced to migrate to the new AGOL flagship app builder (Experience Builder), warts and all. STILL waiting on batch attribute editing, for example.

Re: ArcGIS Online Experience Builder Table number decimal places

JD_GIS — Tue, 20 May 2025 21:05:56 GMT

Workaround: You'll need to go into the map viewer (AGO) where this data is currently represented for your map you're extracting it from. Find the layer you're working with, click on it (in Map Viewer), click fields and find the field you're working with. Make sure it's an int or double (if its a text field, you will have to make a new int or double field and "copy" the values into the new field from the text field). If it is already an int or double click on the check box next to the field you're using, then in the popup, you can change the decimals here, and add comma's etc if necessary.

Re: ArcGIS Online Experience Builder Table number decimal places

JD_GIS — Tue, 20 May 2025 21:06:25 GMT

Oh, and make sure to save the map when done. Otherwise the edits will not show up in the application.

Re: ArcGIS Online Experience Builder Table number decimal places

WillAnderson — Wed, 21 May 2025 17:07:47 GMT

No, this problem persists for us, even if a double/float attribute field settings are configured to be limited to 1 or 2 decimals in the layer, either saved as HLF/layer Viz properties or saved in a map with settings disconnected. We still get this issue when data is viewed in Experience Builder Attribute Table.

Re: ArcGIS Online Experience Builder Table number decimal places

WillAnderson — Wed, 21 May 2025 17:08:42 GMT

And also, an integer field would not be expected to have decimal places anyway so not sure about the workaround you suggest. Haven't had any issues with integers.

Re: ArcGIS Online Experience Builder Table number decimal places

AndreasHall — Wed, 28 May 2025 09:18:57 GMT

Among the Features planned for 2025 in Experience Builder is format number and date/time included for ArcGIS Online Q2 release (June). I still do not have any insights in what this exactly means but perhaps it will solve this issue.

Re: ArcGIS Online Experience Builder Table number decimal places

Goldendelicious — Wed, 03 Sep 2025 23:48:08 GMT

I am also having this problem in a chart. I made a separate post about it, referencing this post. I don't know if this will work for you, but my work around is to set a character limit on the relevant axis. It's not perfect because it makes an ellipse, but at least the decimal places aren't out of control.