Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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" ====
{{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

Knowledge Base

User Tools

Site Tools

Page Tools