Data Formatters

Configure how numbers, currencies, dates, percentages, and custom values are displayed across charts, tables, and reports in OpenAnalyst.

Number Formatting

Number formatting controls apply globally as workspace defaults and can be overridden per chart or per column in tables. Access global defaults at Settings > Data Formatters > Numbers.

  • Decimal places — Set from 0 to 10. Auto mode shows the minimum significant digits without trailing zeros.
  • Thousands separator — Comma (,), period (.), space, or none. Default follows the workspace locale.
  • Abbreviation — Automatically abbreviate large numbers: 1,000 → 1K, 1,000,000 → 1M, 1,000,000,000 → 1B.
  • Prefix and suffix — Add arbitrary text before or after the formatted number (e.g., a unit label such as "units" or "sessions").
// Example format string syntax
"#,##0.00"          → 1,234.56
"#,##0"             → 1,235
"0.0%"              → 23.4%
"$#,##0.00"         → $1,234.56
"#,##0 units"       → 1,235 units
"0.00e+0"           → 1.23e+3

Currency Formats

Currency formatting applies the correct symbol, position (prefix or suffix), and decimal convention for your chosen currency. OpenAnalyst supports all ISO 4217 currencies. To set the workspace default currency, go to Settings > Data Formatters > Currency.

CurrencyCodeExample
US DollarUSD$1,234.56
EuroEUR1.234,56 €
British PoundGBP£1,234.56
Japanese YenJPY¥1,235
Indian RupeeINR₹1,234.56

Date and Time Formats

Date and time display format is controlled separately from the data storage format. OpenAnalyst stores all timestamps in UTC and converts to the user's configured timezone for display. The workspace timezone is set in Settings > General and can be overridden per user in profile settings.

Common date display formats:

  • YYYY-MM-DD — ISO 8601: 2026-02-27
  • MM/DD/YYYY — US format: 02/27/2026
  • DD/MM/YYYY — European format: 27/02/2026
  • MMM D, YYYY — Long format: Feb 27, 2026
  • YYYY-MM-DD HH:mm — With time: 2026-02-27 14:30

Percentage Formatting

Percentage columns can be stored as decimals (0.234 = 23.4%) or as whole numbers (23.4 = 23.4%). Specify the input type when configuring the formatter so OpenAnalyst applies the correct multiplier for display. Percentage formatters include decimal place control and an option to show the sign (+ or -) explicitly.

Conditional Formatting in Tables

Conditional formatting applies visual cues — color fills, text color, or icons — to table cells based on their value. Rules are defined per column in the table editor.

  1. Open the table editor and select a column.
  2. Click Conditional Formatting in the column settings panel.
  3. Add one or more rules. Each rule has a condition (greater than, less than, between, equals, contains) and a style to apply.
  4. Rules are evaluated in order — the first matching rule is applied.
  5. Click Apply to preview and save.

Tip: Use a color scale (gradient from red to green across a value range) to instantly communicate magnitude in KPI tables without requiring readers to read individual numbers.

Locale Settings

The workspace locale governs the default thousands separator, decimal mark, and date format. It is set in Settings > General > Locale. Individual users can override the locale in their profile settings — this affects only their own view of data and does not change how data is stored or how exports are formatted when triggered by scheduled pipelines.