General - Formats
In this section of the settings, the date and time format for DataStudio can be chosen and also the number format.
Date and Time Format Settings
| Setting | Description | Example |
|---|---|---|
UTC (ISO8601) |
DataStudio will display timestamps as UTC time, formatted according to the ISO 8601 standard. This format cannot be changed by the user. |
|
Local Time Format |
Local Time Format Timestamps with the local time offset, using the format given by the operating system’s regional settings. This is defined by the operating system so cannot be changed by the user. |
|
Custom |
When selected, a custom date and time format can be specified in the adjacent fields (date, date and time separator, time). Custom timestamps use the local time offset. |
|
Show Milliseconds |
Select the checkbox to display milliseconds as part of timestamp. |
|
Special Datetime Formats |
This setting controls how the VT_DATE value is shown where the Date value has special meaning. Choose Simple, Traditional or _Full_from the drop-down menu. |
Simple - Every value below the 1970-01-01 12.00 AM (Minimum Posix Epoch) is shown as 'no timestamp'. Traditional - All values that translate to 1899-01-01 12:00:00 (VT_DATE with a float value of 0.0) are shown with timestamp only. Full - Date part of the value will be shown as is, according to the local number settings. |
Number Format Settings
| Setting | Description |
|---|---|
Precision |
Maximum number of displayed digits for a number. |
Decimal Places |
Maximum number of displayed decimal digits (to the right of the decimal point) for a number. If a decimal places number is configured individually for an object then it will override this number. |
Digit Grouping |
Select this checkbox to group digits to the left of a number’s decimal point using the settings defined in the local language settings. |