topic Re: Without changing browser language settings, in published report how to display French style numbers that use space and not comma in ArcGIS Insights Questions

Without changing browser language settings, in published report how to display French style numbers that use space and not comma

Ming — Fri, 24 Nov 2023 20:52:51 GMT

You can add a $ sign behind a number in Insights Enterprise or Desktop v2023.2, but you cannot configure the number display to be in the French manner, where a space is used in place of a comma. When using Insights desktop, you can alter the language settings to see a space instead of a comma. However, once published, if the browser language setting is still set to English, the comma will once again appear.

Desktop:

Browser:

Base on the documentation, it looks the browser language setting is the only option:

https://doc.arcgis.com/en/insights/latest/administer/set-language.htm

Re: Without changing browser language settings, in published report how to display French style numbers that use space and not comma

AkshayHarshe — Fri, 01 Dec 2023 18:50:47 GMT

@Ming I believe this is an expected behavior in a web application. The numbers and dates should be displayed according to the viewer's preference or browser region rather than the editors. The doc you shared mentions:

"Number and date formatting within Insights is based on the app language. For supported languages that use region-specific number and date formats (Arabic (Insights desktop only), English, French, German, Italian, and Spanish), the region is used to determine the default formats for numbers and dates. For Insights in ArcGIS Online and Insights in ArcGIS Enterprise, the region is based on the browser region. "

From the information you provided in the post you are using Insights Desktop in French language but when you share the report to ArcGIS Online it should format according to the browser region or user selection.

Re: Without changing browser language settings, in published report how to display French style numbers that use space and not comma

AkshayHarshe — Fri, 01 Dec 2023 18:58:23 GMT

If you absolutely must, Then I would suggest you create a new calculated field with `CONCAT("$", <Field> ) ` or `SUBSTITUTE(<Field>, ","," ")`

Re: Without changing browser language settings, in published report how to display French style numbers that use space and not comma

Ming — Mon, 04 Dec 2023 16:45:33 GMT

Thank you very much @AkshayHarshe for the response.

In the Substitute function I used space " " to replace the comma ",", in the result the comma is gone but there is no space. Maybe it works for string, but for the field calculation functions, there is no function to convert number to string.

https://doc.arcgis.com/en/insights/2022.1/create/calculate-a-field.htm

Re: Without changing browser language settings, in published report how to display French style numbers that use space and not comma

AkshayHarshe — Wed, 06 Dec 2023 16:53:44 GMT

@Ming I didn't realize that you are using a numeric field in the Reference table card and adding a dollar sign for representation.

you can configure where to place the dollar sign by selecting the field on the reference table card and going to the column formatting:

If you use a numeric field, the substitute formula I sent will not work as the comma is just a representation in certain languages. I do understand it could be an enhancement to let users choose a separator of their choice, but I am not sure if we can justify that as the whole point of i18N language support is to automatically handle these cases according to the browser language.

Re: Without changing browser language settings, in published report how to display French style numbers that use space and not comma

Ming — Wed, 06 Dec 2023 19:01:13 GMT

Thank you @AkshayHarshe,

Will use column formatting and ask client to change browser language setting to French to view the French version.

Because with browser that uses English as preferred language, there is no way to change the Insights labels for the table like "Flip card, Total Records" to French.

Thanks,

Ming