Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

Chart number formatting

reynir
in Charting

Featured Replies

I have a database based on Icelandic localization with the decimal as comma and thousands separator as dot.

 

The numbers are formatted to use system settings.

 

I have a column chart to show percentage of defects. I.e I have in a sample count of items =  40. Then I have defects like brown heads = 2. Calculating ratio of brown heads gives me 2/40 = 0.05. When I format it on a layout to show 5,0 percent. To have it in percentage I multiply by 100. When I format it on a layout it shows 5,0 percent. When I show the same number on a column chart it shows 5,0

 

When I change the localization of the system to USA or Canada system settings and insert the same data with decimal separator as dot and thousands separator as dot the same information show up as 50.0 on the column chart !!!

 

Have you seen this behavior

 

Regards,

Reynir.

 

 

 

Create an account or sign in to comment

https://fmforums.com/topic/95247-chart-number-formatting/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.