This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
on - edited on by
AlinaMalynovska
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-c3b0ee...).
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.
Hi Oleh,
I want to automatically provide relevant date formats to our clients according to their country as it is described above. However, currently it doesn't work like this. Here are the formatting options I have with both my Chrome and device language being set to English (US).
Nothing changed after setting both my Chrome and Windows language to English (UK) - neither the options nor the visualised format. It looks like the formatting options hardcode the date format. What am I missing?
Thank you,
Bori
I would like to bring to your notice that, the provided solution is not working for me. I did check the laptop and browser setting. It seems to be fine. My goal is to change the date format to MM/DD/YYYY and the provided custom option at the bottom in Format does not help in changing the date format. I am attaching an screenshot for reference. Hope you can provide any alternate solution .
Thank you.
