Localization in Sisense, or How to Control Date and Numbers Format

Localization in Sisense, or How to Control Date and Numbers Format

In Sisense, the format of data displayed, such as date and numbers in widgets or filters, is managed by localization. By default, localization is set to be automatically detected based on browser/device settings. This means two users with different settings can see the same widget differently.

There are 2 ways to control the format of dates and numbers, aka the localization:

Browser settings

Language and location selected in browser settings is the easiest way to control the format of date and numbers in Sisense.

In my case both my laptop and browser have English (UK) as the main language:

The result on a dashboard:

If the user is located in another country and therefore has different preferred language/localization selected, the data will appear differently/dynamically.

Using Sisense REST API to define one specific localization

It is also possible to disable the auto-selection of localization and define a specific one:

This Sisense environment has English (US) selected as the default and only localization:

To change this, the REST API endpoint can be triggered with the given payload:

Where "autoDetectEnabled" is whether we take the localization from the browser (true) or specified default one (false).

The list of most common localization can be found here (https://learn.microsoft.com/en-us/openspecs/office_standards/ms-oe376/6c085406-a698-4e12-9d4d-c3b0ee3dbc4a).

After making the changes using REST API, the dashboard looks like this:

Note, this means every user will see the data with the same format despite the country/browser settings.