This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
convert_abbreviative_numbers_to_normal_long_numbers_1k_1000 [2021/05/12 06:04] windsor_ai created |
convert_abbreviative_numbers_to_normal_long_numbers_1k_1000 [2021/05/18 05:08] windsor_ai |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Adjusting formatting of numbers ====== | ||
+ | |||
How to automatically change number formatting in Windsor between no units for values less than 1000, K for thousands, M for millions, and B for billions? | How to automatically change number formatting in Windsor between no units for values less than 1000, K for thousands, M for millions, and B for billions? | ||
Line 4: | Line 6: | ||
==== 1. Click three dots to get a settings window then click "Edit dataset" | ==== 1. Click three dots to get a settings window then click "Edit dataset" | ||
- | {{:ksnip_20210512-080307.png?100|}} | + | {{ksnip_20210512-080307.png|}} |
+ | |||
+ | ==== 2. Select " | ||
+ | {{ksnip_20210512-080755.png|}} | ||
+ | |||
+ | |||
+ | ==== 3. Add a metric name and SQL expression for it ==== | ||
+ | {{ksnip_20210512-081107.png|}} | ||
+ | |||
+ | ==== 4. Scroll down a little bit and change the number format in "D3 FORMAT" | ||
+ | {{ksnip_20210512-081805.png}} | ||
+ | |||
+ | You can set the number format whatever you like from here: http:// | ||
+ |