Skip to main content

Format Tags

Formats 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.

Evidence will also format the column if the column’s name matches any of the accepted format tags exactly (e.g., if your column is named date, Evidence will use the date format).

Accepted Tags#

Below are the currently accepted format tags and their respective formats. Most numbers are formatted with 2 decimal places. This functionality will be extended in future versions to allow for more customization of formats.

Format TypeFormat TagFormat NameExample
DatedateDateMarch 17, 2021
DateweekWeekMarch 14, 2021
DatemonthMonthMar 1, 2021
DateqtrQuarterJan 1, 2021
DateyearYear1994
StringidID355123
StringstrString355123
NumberpctPercent12%
NumberusdCurrency (USD)$1,053.29
NumbercadCurrency (CAD)$1,053.29
NumbereurCurrency (EUR)€1,053.29
NumbergbpCurrency (GBP)£1,053.29
NumberchfCurrency (CHF)CHF1,053.29

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 NameFormatted Title
sales_usdSales ($)
customer_idCustomer ID
growth_pctGrowth (%)
customer_number_strCustomer Number