@formats

Specify the visual formatting of series data in the chart

Quick Reference

-- @formats: integer, currency 

Valid Values

List

@formats must be a comma separated list of formats that map to the columns used within the @series or @secondary-series

• none

• integer

• currency

• percent

Full Example

-- @chart: bar
-- @title: Bar Chart With Formats
-- @subtitle: An example bar chart with formats
-- @formats: currency
SELECT 
Channel,
sum(Amount) as Total_Sales
FROM Sales
WHERE Status = 'Won'
GROUP BY Channel
ORDER BY Total_Sales DESC;

An example bar chart with currency formatting applied to the series

Use Cases

Formats allows you to visually improve the look of number data in your charts to be more clear and visually appealing.

Example Charts

Formats