Changing the Default Date and Time Format

You can change the format (pattern) of recognized time fields in your data on the Fields tab of a data source configuration.

To change a time field's format:

  1. Make sure you are logged in as a Zoomdata administrator.

  2. Select (Settings) and then select Sources. The Data Sources page appears.

  3. In the My Data Sources table on the Data Sources page, locate and select the data source configuration you want to edit. The data source configuration wizard appears.

  4. Select the Fields tab in the data source configuration wizard.

  5. Locate the time field in the list of fields.

  6. In the Configure column of the table, specify the time format (pattern) for the field. The Time Pattern list (with Default displayed) provides two options:

    • Default: Select this option if the time format in the data source conforms to one of the standards recognized by Zoomdata.
    • Custom: Select this option when you need to enter a unique time format. A new text box will appear, allowing you to specify the unique time format.
  7. Specify a granularity for the time field. The Granularity list lets you select the default unit of time to use for this time field.

    Valid granularities are Millisecond, Second, Minute, Hour, Day, Week, Month or Year. If some of these granularity options do not appear, verify that the granularity specified for this field on the Fields tab is set at the correct granularity level. For each field, the available granularity options include all options starting from Year down to the granularity level specified for this field on the Fields tab.

    The refinement level of the field data in a data store defines the minimum level of granularity that should be set for the field. Specifying granularity for a field that is lower than the refinement level of the field data will not produce a chart with data grouped at the requested lower level. For example, if a field's data is stored in hours, requesting the granularity of that data lower than hours will produce the values up to the hour level, and the more detailed level information will be zeros (i.e., 0 minutes, 0 seconds, and 0 milliseconds).
  8. Specify the time zone for the time field. The Time Zone option lets you select a time zone: The time zone label will be displayed in charts and dashboards for this data source.

  9. When your changes are complete, click Save, Save & Next, or Finish (depending on the tab) to save the data source configuration and close the wizard.