cancel
Showing results for 
Search instead for 
Did you mean: 
OlehChudiiovych
Sisense Team Member
Sisense Team Member

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:

OlehChudiiovych_0-1671718800204.png

The result on a dashboard:

OlehChudiiovych_0-1671717126385.png

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:

OlehChudiiovych_2-1671717854948.png

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

OlehChudiiovych_3-1671717901744.png

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.

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

OlehChudiiovych_4-1671718032143.png

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

 

Version history
Last update:
‎12-22-2022 08:32 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request