User Tools

Site Tools


convert_abbreviative_numbers_to_normal_long_numbers_1k_1000

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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] (current)
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 "Metrics" and then click "Add item" ==== 
 +{{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" field  for example to '.2f' ==== 
 +{{ksnip_20210512-081805.png}} 
 + 
 +You can set the number format whatever you like from here: http://bl.ocks.org/zanarmstrong/05c1e95bf7aa16c4768e 
 + 
convert_abbreviative_numbers_to_normal_long_numbers_1k_1000.1620795887.txt.gz · Last modified: 2021/05/12 06:04 by windsor_ai