LogoLogo
Home
  • Verb Documentation
  • Release Notes
  • Environment Settings
    • Authentication
      • Authentication Endpoint
  • Data Sources
    • Ingestion Methods
    • Table Sync Intervals
    • Data Source Integrations
      • Network Permissions
      • Microsoft SQL Server
      • PostgreSQL
      • MongoDB
      • Snowflake
      • Elasticsearch
      • DynamoDB
      • Google BigQuery
      • Firebase Cloud Firestore
      • Supabase
      • Cloud Files
      • Flat Files
    • Data Synchronization
      • Synchronization Methods
        • Full Synchronization
        • Incremental Synchronization
        • Change Tracking
        • Change Data Capture
      • Synchronization Intervals
      • Synchronization Status
        • Pausing and Resuming
      • Synchronization History
      • Schema Changes
      • Row Filtering
      • Schemaless & NoSQL
      • Managing Connections
      • Troubleshooting
  • Models
    • What is a Model
      • Elements of a Model
      • Model Management
    • Building a Model
      • Add/Remove Data
      • Relationships
      • Row-Level Security
      • Transformations
    • Advanced Model Information
      • Database Keys
      • Unstructured Data
      • Publishing Updates
      • Troubleshooting
      • Automatic Modeling
  • Data Transformations
    • What is a Transformation
      • Elements of a Transformation
      • Transformation Management
    • Building Transformations
      • Creating Transformations
      • Configure Transformation Steps
      • Transformation Steps
        • Calculator
        • Manipulate Text
        • Map Values
        • Remove Duplicates
        • Date Operation
        • Select Columns
        • Change Type
        • Group Data
        • Filter Data
        • Join Data
        • Append Rows
        • Pivot Data
        • Rank Data
        • Window Data
      • Complete and Publish
  • Collections
    • What is a Collection
      • Elements of a Collection
    • Building Collections
    • API Collections
      • Building API Collections
        • Connect Data Sources
        • Data Model
        • Select Data
        • Authentication and Security
        • Data Access API Keys
        • Data Access API Documentation
      • API Collection Versions
    • Advanced Collection Options
      • Time Zones
      • Currency Symbols
  • Tiles
    • What is a Tile
      • Elements of a Tile
    • Tile Management
      • Tile Data
    • Tile Actions
    • Custom Date Formats
    • Currency Conversion
  • Design Themes
    • What is a Design Theme
    • General Theme Settings
    • Data Visualization Settings
  • Account Settings
    • Integrations
      • Slack
  • Legal
    • Terms of Use
    • Privacy Policy
    • Subscription Agreement Terms
    • Subscription Agreement
    • Data Processing Addendum
Powered by GitBook
On this page
  • End-User Time Zone Conversion
  • Programmatic (SDK) Conversion
  • Collection Specific Details
  • What if Data is Not in UTC in My Data Source?

Was this helpful?

  1. Collections
  2. Advanced Collection Options

Time Zones

Configure time zones for collections and tile

PreviousAdvanced Collection OptionsNextCurrency Symbols

Last updated 3 years ago

Was this helpful?

Verb attempts to convert time-based data when your data is ingested. By default, time-based data is stored in Universal Coordinated Time (UTC). While a UTC format will work for the vast majority of scenarios, there are situations where the output data needs to be converted to a given time zone instead of UTC. To convert the data, use the transformation feature to create a calculated column or data view in the model. Verb provides a

End-User Time Zone Conversion

The time zone picker can be displayed to end-users so that they may convert data to their preferred time zone.

End-Users will view this option from the date filter if one is displayed. If there is no date filter displayed then the time zone picker will display as a button in the filter area.

The menu will show UTC selected by default and the end-user's local browser time will be listed as the second menu option.

The time zone list contains a complete list of standard global time zones as well as common aliases such. For example, both "America/Chicago" and "US/Central" will render a report with a time zone offset of -6 (or -5 hours depending on whether daylight saving time is in effect) from UTC.

Programmatic (SDK) Conversion

To convert the time zone programmatically, pass the preferred time zone into the x-timezone property in the SDK. Time zone codes will follow ISO standards.

Collection Specific Details

Dashboard Collections

To configure end-user time zone controls on a dashboard collection go to the Filters Tab and turn on the Time Zone Conversion toggle at the bottom of the panel.

Programmatic options are available on dashboard collections regardless of the Time Zone Conversion toggle configuration.

Contextual Tile Collections

Contextual Tiles only allow for programmatic conversion of the time zone via the SDK.

API Collections

API collections will always present data in UTC.

What if Data is Not in UTC in My Data Source?

Verb assumes that all date-time information is in UTC upon ingestion and when data is presented in a collection it will be shown as though it is UTC.

If the data is not stored in the source as UTC then it's important to convert it to correctly show date-time information. To convert the data, use the transformation feature to create a calculated column or data view in the model. Verb provides a

Convert Time Zone transformation step.
Convert Time Zone transformation step.
SDK Embed Code