Data Manipulation Enhancements

The following enhancements were made in Zoomdata 4 that target data handling and manipulation.

  1. This release introduces second and millisecond support in date and time data. You can now request that date and time data be processed using second or millisecond granularities. You will see second and millisecond options now when working with the following Zoomdata features:

    • Data source configuration time field granularity and custom range settings
    • Data source configuration default chart granularity settings (when a time field is selected in the default chart settings)
    • Data source configuration global default time bar settings
    • Data source custom ranges
    • Filter settings for time fields on charts
    • Time bar settings
    • Time field granularities on charts
    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).
  2. Fields with a MONEY field type are now automatically converted to the NUMBER field type. The MONEY field type is no longer supported. You can specify formatting (such as the currency symbol) for NUMBER fields containing currency data in your data source configurations. See Configuring Number Formatting.

  3. You can now use derived fields in WHERE clauses in custom metrics. In prior versions, derived fields could not be used. See Supported SQL-Like Expressions.

  4. Hidden source and derived fields can now be used in other derived fields. Note that they still cannot be used in custom metrics or in dashboard charts. See Hiding Fields.

  5. A new time_diff row-level function can now be used in row-level expressions for derived fields. This row-level function allows you to obtain the difference between the values of two time fields in the date/time unit you require. The syntax of the time_diff row-level function is:

    time_diff('<timepart>', <end_date_field>, <start_date_field>)

    See Time Functions for more information.