Skip to main content

Formatting your Measures!

When creating your measures in Rill, you have the option to pick from a preset of formats that we provide to you or use the d3-format parameter to format your data in any way you like. While the big number in the explore dashboard won't apply all the decimals changes (it will add currency or percentage if that is the type), you will be able to see the changes in the dimension leaderboard and pivot tables.


Using format_d3 to control the format of a measure in the metrics view allows for further customization.

Invalid format Strings

If an invalid format string is supplied, measures will be formatted with format_preset: humanize. If neither format_preset nor format_d3 is supplied, measures will be formatted with the humanize preset).

Cannot have both

Measures cannot have both format_preset and format_d3 entries.

Please review the reference documentation, here.

Customization​

For further customization of your measures, you can swtich to the YAML view and with our metrics view reference documentation use the format_d3_locale parameter to create specific formatting.

 format_d3: 
  format_d3_locale: 
    grouping: 
    currency:

Examples​

As explained in the introduction, you'll notice that in each of the screenshot the Big Number doesn't always follow the exact formatting, but will change based on percentage / currency formatting. This is as designed as there is a fixed width that the number has to be displayed. Instead you'll see these values in the dimension leaderboard, TDD and pivot tables.

If you have any quesitons, please review our reference documentation.

Format a measure to include specific amount of decimals​


In the case that you need to view more granular values of your data, you can set the decimal places to whatever value you need. In the above example, we are setting the average voltage measure to 4 decimals spots to get a more accurate representation for each dimension.

format_d3: ".4f"

Format currency with different ',' locations. IE: Indian Rupee​


format_d3: "$,"
format_d3_locale: 
    grouping: [3, 2, 2]
    currency: ["₹", ""]

As Indian Rupees are formatted in a different way than USD and EUR, you'll need to use the format_d3_locale parameter to set the exact grouping and currency. Likewise if the currency symbol is written after the numeric value, you can set the currency to ["". "$"].

Percentages​


format_d3: '.4%'

While our format_preset: percentage will automatically apply .2%, you can manually set the value in format_d3 if you are looking for a more specific measure format.

Demo​

See this project live in our demo!