Number Formatting Support for Japanese Users

[Suryakant]

Background and customer pain points

Currently Sisense is capable of showing numeric figures in abbreviated format, but only in the American/European short scale form: thousand (k), million (M), billion (B), trillion (T). In east Asian countries, there is a different scale form, so viewing information in these k/M/B/T is very difficult to understand. 

Non-abbreviated	Standard abbreviation (US/Europe)	Indian abbreviation	East Asian abbreviation
1,000	1 k (thousand)	1,000	1 千
10,000	10 k	10,000	1 万
100,000	100 k	1 lakh	10 万
1,000,000	1 M (Million)	10 lakh	100 万
10,000,000	10 M	1 crore	1000 万
100,000,000	100 M	10 crore	1 億
1,000,000,000	1 B (Billion)	1 arab	10 億
10,000,000,000	10 B	10 arab	100 億
100,000,000,000	100 B	1 kharab	1000 億
1,000,000,000,000	1 T (Trillion)	10 kharab	1 兆

Business case description/value

To be able to select the scale form for number abbreviations for different APAC regions as well.

Use case

1. A user in Europe is creating a dashboard in Insights with an indicator to show total profit in an Indicator form. Let's suppose that the total profit to display is 1,610,000. 2. Europe user formats the content to abbreviate the display in the short scale form. User will see "1.61 M". 3. A user in Japan is creating the exact same dashboard on the same data. 4. Japan user formats the content to abbreviate the display in Asian scale form. User will see "161 万". 5. A user in India is creating the exact same dashboard on the same data. 6. India user formats the content to abbreviate the display in the India scale form. User will see "16.1 Lakh".