Number Formatting
Formats for numbers and dates are defined using the column names in your SQL query.
A format tag can be appended to your column name to ensure the right format (see table below for accepted tags).
Format tags are appended with an underscore: for example, to append the percentage format to a column named growth, it would be growth_pct.
Formatting can be configured in the Value Formatting Section of the Evidence Settings.
Format tags are case-insensitive, so growth_pct and GROWTH_PCT are equivalent.
Built-in Value Format Tags
Evidence supports a variety of date/time, number, percentage, and currency formats. You can find the full list of format tags below
Custom Value Format Tags
Custom formats can be added in the Value Formatting Section of the Evidence Settings. Formats can be coded using Excel style custom format codes.
Title Formatting
When creating a table, Evidence formats column titles based on the name of the column and its format tag. Format tags that do not add to the meaning of the column name are not printed as part of the title.
Examples
| Column Name | Formatted Title |
|---|---|
| sales_usd | Sales ($) |
| customer_id | Customer ID |
| growth_pct | Growth |
| customer_number_num2k | Customer Number |
Large Numbers
Evidence automatically formats large numbers into shortened versions based on the size of the median number in a column (e.g., 4,000,000 → 4M).
You can choose to handle these numbers differently by choosing a specific format code. For example, if Evidence is formatting a column as millions, but you want to see all numbers in thousands, you could use the num0k format tag, which will show all numbers in the column in thousands with 0 decimal places.
Format Reference
Dates
| Format Tag | Format Code | Example Input | Example Output |
|---|---|---|---|
| ddd | ddd | 2022-01-09 12:45 | Sun |
| dddd | dddd | 2022-01-09 12:45 | Sunday |
| mmm | mmm | 2022-01-09 12:45 | Jan |
| mmmm | mmmm | 2022-01-09 12:45 | January |
| yyyy | yyyy | 2022-01-09 12:45 | 2022 |
| shortdate | mmm d/yy | 2022-01-09 12:45 | Jan 9/22 |
| longdate | mmmm d, yyyy | 2022-01-09 12:45 | January 9, 2022 |
| fulldate | dddd mmmm d, yyyy | 2022-01-09 12:45 | Sunday January 9, 2022 |
| mdy | m/d/y | 2022-01-09 12:45 | 1/9/22 |
| dmy | d/m/y | 2022-01-09 12:45 | 9/1/22 |
| hms | H:MM:SS AM/PM | 2022-01-09 12:45 | 11:45:03 AM |
Currencies
Supported currencies:
| Code | Currency |
|---|---|
| USD | United States Dollar |
| AUD | Australian Dollar |
| BRL | Brazilian Real |
| CAD | Canadian Dollar |
| CNY | Renminbi |
| EUR | Euro |
| GBP | Pound Sterling |
| JPY | Japanese Yen |
| INR | Indian Rupee |
| KRW | South Korean won |
| NGN | Nigerian Naira |
| RUB | Russian Ruble |
| SEK | Swedish Krona |
In order to use currency tags, use the currency code, optionally appended with:
- a number indicating the number of decimal places to show (0-2)
- a letter indication the order of magnitude to show ("","k", "m", "b")
For example, the available tags for USD are:
| Format Tag | Format Code | Example Input | Example Output |
|---|---|---|---|
| usd | auto | 412.17 | $412 |
| usd0 | $#,##0 | 7043.123 | $7,043 |
| usd1 | $#,##0.0 | 7043.123 | $7,043.1 |
| usd2 | $#,##0.00 | 7043.123 | $7,043.12 |
| usd0k | $#,##0,"k" | 64301.12 | $64k |
| usd1k | $#,##0.0,"k" | 64301.12 | $64.3k |
| usd2k | $#,##0.00,"k" | 64301.12 | $64.30k |
| usd0m | $#,##0,,"M" | 4564301.12 | $5M |
| usd1m | $#,##0.0,,"M" | 4564301.12 | $4.6M |
| usd2m | $#,##0.00,,"M" | 4564301.12 | $4.56M |
| usd0b | $#,##0,,,"B" | 9784564301.12 | $10B |
| usd1b | $#,##0.0,,,"B" | 9784564301.12 | $9.8B |
| usd2b | $#,##0.00,,,"B" | 9784564301.12 | $9.78B |
Numbers
| Format Tag | Format Code | Example Input | Example Output |
|---|---|---|---|
| num0 | #,##0 | 11.23168 | 11 |
| num1 | #,##0.0 | 11.23168 | 11.2 |
| num2 | #,##0.00 | 11.23168 | 11.23 |
| num3 | #,##0.000 | 11.23168 | 11.232 |
| num4 | #,##0.0000 | 11.23168 | 11.2317 |
| num0k | #,##0,"k" | 64201 | 64k |
| num1k | #,##0.0,"k" | 64201 | 64.2k |
| num2k | #,##0.00,"k" | 64201 | 64.20k |
| num0m | #,##0,,"M" | 42539483 | 43M |
| num1m | #,##0.0,,"M" | 42539483 | 42.5M |
| num2m | #,##0.00,,"M" | 42539483 | 42.54M |
| num0b | #,##0,,,"B" | 1384937584 | 1B |
| num1b | #,##0.0,,,"B" | 1384937584 | 1.4B |
| num2b | #,##0.00,,,"B" | 1384937584 | 1.38B |
| id | 0 | 921594675 | 921594675 |
| fract | # ?/? | 0.25 | 1/4 |
| mult | #,##0.0"x" | 5.32 | 5.3x |
| mult0 | #,##0"x" | 5.32 | 5x |
| mult1 | #,##0.0"x" | 5.32 | 5.3x |
| mult2 | #,##0.00"x" | 5.32 | 5.32x |
| sci | 0.00E+0 | 16546.1561 | 1.65E+4 |
Percentages
| Format Tag | Format Code | Example Input | Example Output |
|---|---|---|---|
| pct | auto | 0.731 | 73.1% |
| pct0 | #,##0% | 0.731 | 73% |
| pct1 | #,##0.0% | 0.731 | 73.1% |
| pct2 | #,##0.00% | 0.731 | 73.10% |
| pct3 | #,##0.000% | 0.731 | 73.100% |