Change Number Format

You can use the API to set custom thousands and decimal separators, with values up to 8 characters in length. These settings can be applied at the organizational, workspace, or user level to best suit your organization’s preferences.

Side-by-side comparison of two headline visualizations showing the same numeric value formatted with different separators. The left headline uses commas for thousands, while the one on the right uses periods.

Organization

To change the number format for your entire organization, follow these steps.

Steps:

  1. Go to the Workspaces tab and open the workspace you want to edit. Open the Settings tab and click Change next to Number separators.

    Settings tab showing the Number separators row with a current setting displayed as comma and period. The Change button is at the right side of the row.

    Dialog opens:

    The Number separators dialog with a number format dropdown.
  2. Select a number format and click Apply.

If none of the listed options fit your use case, you can use the API to create your own custom number separators.

Make the following API call:

curl $HOST_URL/api/v1/entities/organizationSettings \
-H "Content-Type: application/vnd.gooddata.api+json" \
-H "Accept: application/vnd.gooddata.api+json" \
-H "Authorization: Bearer $API_TOKEN" \
-X POST \
-d '{
  "data": {
    "attributes": {
      "content": {
        "thousand": " ",
        "decimal": ","
      },
      "type": "SEPARATORS"
    },
    "id": "<your_custom_id>",
    "type": "organizationSetting"
  }
}' | jq .

Workspace

To change the number format for workspace, make the following API call:

curl $HOST_URL/api/v1/entities/workspaces/<workspace_id>/workspaceSettings \
-H "Content-Type: application/vnd.gooddata.api+json" \
-H "Accept: application/vnd.gooddata.api+json" \
-H "Authorization: Bearer $API_TOKEN" \
-X POST \
-d '{
  "data": {
    "attributes": {
      "content": {
        "thousand": " ",
        "decimal": ","
      },
      "type": "SEPARATORS"
    },
    "id": "<your_custom_id>",
    "type": "workspaceSetting"
  }
}' | jq .

User

To change the number format for an individual user, make the following API call:

curl $HOST_URL/api/v1/entities/users/<user_id>/userSettings \
-H "Content-Type: application/vnd.gooddata.api+json" \
-H "Accept: application/vnd.gooddata.api+json" \
-H "Authorization: Bearer $API_TOKEN" \
-X POST \
-d '{
  "data": {
    "attributes": {
      "content": {
        "thousand": " ",
        "decimal": ","
      },
      "type": "SEPARATORS"
    },
    "id": "<your_custom_id>",
    "type": "userSetting"
  }
}' | jq .