Preferences
The Preferences section allows you to customize various settings for your organization, including general preferences and data formatting options. It is available to organization admins in the ADMIN group of the gear menu in the top-right corner of the Cluvio UI.
When signing up, the data formatting is pre-configured from a country preset matching your location; you can adjust it here at any time.
General
The General section lets you configure organization-wide settings.
Organization Time Zone
Set the default time zone for your organization. It is used for sending alerts and scheduled e-mails at the desired time, and for dashboards' refresh anchor times. It does not, on its own, affect the data shown in reports, but it can be selected as a Dashboard Time Zone — see Organization Time Zone for details.
Week Starts
Choose which day of the week should be considered the first day:
- Monday - Common in Europe and many other countries
- Sunday - Common in the United States and some other countries
This setting affects week-based aggregations and date filters throughout your dashboards and reports.
Note: After changing this setting, you may need to update the saved default aggregation on your dashboards.
CSV Column Separator
Select the character used to separate columns when exporting data to CSV format:
- Comma (,) - Standard CSV format
- Semicolon (;) - Common in European countries where comma is used as decimal separator
- Tab - Tab-separated values format
Data Formatting
The Data Formatting section allows you to configure how numbers, dates, and times are displayed throughout your Cluvio dashboards and reports.
Country Presets
For quick setup, you can apply formatting settings based on common regional standards. Click Apply Country Preset and select from popular countries including:
- United States
- United Kingdom
- Germany
- France
- Spain
- Italy
- Netherlands
- Switzerland
- Canada
- Australia
- India
- Japan
- China
- Brazil
- Mexico
- South Korea
When you select a country preset, Cluvio automatically configures all data formatting settings according to that country's conventions. You can preview the settings and either:
- Save - Apply the preset settings
- Cancel - Discard the changes
- Customize... - Fine-tune individual settings based on the preset
Date Format
Specify how dates are displayed in your reports. Common formats include:
MM/DD/YYYY- US format (e.g., 12/31/2024)DD/MM/YYYY- European format (e.g., 31/12/2024)YYYY-MM-DD- ISO format (e.g., 2024-12-31)DD.MM.YYYY- German format (e.g., 31.12.2024)
See the Advanced Formatting section for detailed formatting options.
Time Format
Configure how times are displayed:
h:mm:ss A- 12-hour format with AM/PM (e.g., 3:45:30 PM)HH:mm:ss- 24-hour format (e.g., 15:45:30)h:mm A- 12-hour format without seconds (e.g., 3:45 PM)HH:mm- 24-hour format without seconds (e.g., 15:45)
Date-Time Format
Define how combined date and time values are displayed. This format typically combines your date and time formats:
MM/DD/YYYY h:mm:ss A- US format (e.g., 12/31/2024 3:45:30 PM)DD/MM/YYYY HH:mm:ss- European format (e.g., 31/12/2024 15:45:30)YYYY-MM-DD HH:mm:ss- ISO format (e.g., 2024-12-31 15:45:30)
Thousand Separator
Choose the character used to separate thousands in large numbers:
- No separator (e.g., 1000000)
- Space - Used in France and other countries (e.g., 1 000 000)
- Dot - Used in many European countries (e.g., 1.000.000)
- Comma - Used in US, UK, and other English-speaking countries (e.g., 1,000,000)
- Slash (e.g., 1/000/000)
The Switzerland country preset additionally uses the apostrophe separator customary there (e.g., 1'000'000).
Decimal Separator
Select the character used to separate the decimal part of numbers:
- Dot - Used in US, UK, and other English-speaking countries (e.g., 3.14)
- Comma - Used in many European countries (e.g., 3,14)
- Slash (e.g., 3/14)
The thousand separator and decimal separator should be different characters to keep numbers unambiguous.
Currency Symbol
Specify the currency symbol to display in financial values:
$- US Dollar€- Euro£- British Pound¥- Japanese Yen / Chinese Yuan₹- Indian Rupee₩- South Korean Won- Or any other currency symbol
Currency Symbol Position
Choose whether the currency symbol appears before or after the number:
- Before - Symbol appears before the number (e.g., $1,234.56)
- After - Symbol appears after the number (e.g., 1 234,56€)
Large Number Abbreviations
Configure the abbreviations used for large numbers in charts and reports:
- Thousand - Default:
k(e.g., 5k for 5,000) - Million - Default:
m(e.g., 2m for 2,000,000) - Billion - Default:
mm(e.g., 1mm for 1,000,000,000) - Trillion - Default:
bn(e.g., 3bn for 3,000,000,000,000)
Country presets set these to the locally customary abbreviations (e.g., K / M / B / T for the United States). These abbreviations help make large numbers more readable in visualizations where space is limited.
Advanced Formatting
Moment.js Date and Time Formatting
Cluvio uses Moment.js for date and time formatting. You can create custom formats using the following tokens:
Date Tokens
| Token | Output | Description |
|---|---|---|
M | 1-12 | Month number |
MM | 01-12 | Month number with leading zero |
MMM | Jan-Dec | Month abbreviation |
MMMM | January-December | Full month name |
D | 1-31 | Day of month |
DD | 01-31 | Day of month with leading zero |
d | 0-6 | Day of week (Sunday is 0) |
dd | Su-Sa | Minimal day name |
ddd | Sun-Sat | Short day name |
dddd | Sunday-Saturday | Full day name |
YY | 24 | Two-digit year |
YYYY | 2024 | Four-digit year |
Time Tokens
| Token | Output | Description |
|---|---|---|
H | 0-23 | Hour (24-hour format) |
HH | 00-23 | Hour with leading zero (24-hour format) |
h | 1-12 | Hour (12-hour format) |
hh | 01-12 | Hour with leading zero (12-hour format) |
m | 0-59 | Minute |
mm | 00-59 | Minute with leading zero |
s | 0-59 | Second |
ss | 00-59 | Second with leading zero |
A | AM/PM | Post or ante meridiem (uppercase) |
a | am/pm | Post or ante meridiem (lowercase) |
Common Format Examples
| Format | Example Output |
|---|---|
YYYY-MM-DD | 2024-12-31 |
DD/MM/YYYY | 31/12/2024 |
MM/DD/YYYY | 12/31/2024 |
MMMM D, YYYY | December 31, 2024 |
ddd, MMM D | Tue, Dec 31 |
HH:mm:ss | 15:45:30 |
h:mm:ss A | 3:45:30 PM |
YYYY-MM-DD HH:mm:ss | 2024-12-31 15:45:30 |
DD.MM.YYYY HH:mm | 31.12.2024 15:45 |
MMM D, YYYY h:mm A | Dec 31, 2024 3:45 PM |
You can combine these tokens with any separator characters (spaces, slashes, periods, hyphens, etc.) to create custom formats that match your organization's conventions.
Note: Data formatting preferences apply organization-wide to all users.