User Tools

Site Tools


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?

It is possible to change the number format only for metrics and calculated columns. If you don't have a metric, you can create a metric based on your field with some aggregation function.

1. Click three dots to get a settings window then click "Edit dataset"

2. Select "Metrics" and then click "Add item"

3. Add a metric name and SQL expression for it

4. Scroll down a little bit and change the number format in "D3 FORMAT" field for example to '.2f'

You can set the number format whatever you like from here:

convert_abbreviative_numbers_to_normal_long_numbers_1k_1000.txt · Last modified: 2021/05/18 05:08 by windsor_ai