Table of Contents
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: http://bl.ocks.org/zanarmstrong/05c1e95bf7aa16c4768e