Fields Tab

Use the Fields tab in the data source configuration wizard to configure settings for fields within the data source table you selected on the Tables/Indices Tab. You can also add derived fields or custom metrics to the data using this tab. The tailored and defined fields on this tab are then used as attributes and metrics for visuals that use the data source configuration.

You must be logged in as an administrator or as a user with the group privilege Can Create new Data Sources to see the Fields tab of the data source configuration wizard.

The Fields tab is split into four tables.

When you are finished reviewing and modifying these tables (as needed), select to proceed to the Refresh Tab in the data source configuration wizard. Select to return to the Tables/Indices Tab.

The Field Table

The field table is the top table on the Fields tab. It lists all the fields in the records of the data source collection or table you selected on the Tables/Indices Tab and allows you to configure them. To define the field metadata, 1,000 records are sampled.

The following table describes the settings you can alter for your data fields. The Field ID column shows the ID of the data field in the data record. If you select the associated with a data field, the date and time of the last refresh for that field display. To refresh your data source metadata, select underneath the field table. (See Trigger Refresh Jobs for more information.)

Setting Description

By default, all the fields are selected and are visible. This means that you can visualize the data from these fields on your visuals. If you want to hide specific fields, clear the corresponding checkboxes. Hidden fields can be used in derived fields. However, they cannot be used in custom metrics or dashboard visuals.

Source and derived fields cannot be hidden if they are already used in a custom metric, a dashboard visual, or the default visual settings for a data source configuration. Consequently, the best time to hide a field is when you set up a data source configuration for the first time, before they are used. See Hide Fields.

Field ID The name of the field in the data from the data store. Note that Composer supports only underscores and periods in data store field names. No other special characters or white space are supported. The names can start with a letter or an underscore, followed by letters, digits, underscores, and periods. If your data store uses special characters other than underscores and periods in field names, please remove them and then try to create this data source configuration again.

By default, the names of the fields from your data source are used as labels on your visuals. Change the labels in this column as needed.


The type for each field is defined, by default, by Composer. The default data types are displayed in the Type column. You can change the type of a field by selecting another option from the drop-down list.

You can set the maximum character length of attribute fields. By default, it is limited to 200 characters and the field is recognized as an Attribute. If this limit is exceeded, the field will be recognized as a Text field. Add or modify the FieldsTypeDetector​ property in the file as required.

If you want to use a field in row-level expressions, do not change its original field type. Changing the field type of the original field may generate errors for the row-level expressions. Instead, change the field type in a derived field created from the original field and then use the new derived field in your row-level expressions.

Partition If you are using Cloudera Impala, Apache Drill, Hive, or Spark SQL as your data source, the Partitioned column shows if fields within your source are partitioned.

The Configure column allows you to configure each field.

  • For metrics, you can define the default aggregation function: SUM, AVG, MAX, MIN, or (for some data sources) LAST_VALUE. See Metric Aggregation Functions.

  • For number fields, you can define the number format used. Select the format to display the Format dialog and use the dialog to define the number format. Options for number formats include Plain Number, Percentage, Money, Storage, and Scientific Notation. Each format provides unique settings on the Format dialog. For example, if you select Storage, you can set the units used for the field to bytes, kilobytes, megabytes, gigabytes, terabytes, petabytes, or exabytes.

    You can select the Apply to all number fields in <data source> checkbox to apply the number format to all the number fields in this data source definition. Select Apply to apply your number format changes.

  • For time fields, you can set the time pattern, granularity and time zone. Time patterns are either Default or Custom. If you select Custom, you can set the time pattern (by default YYYY-MM-DD format).

    Granularity can be set to Millisecond, Second, Minute, Hour, Day, Week, Month, Quarter, or Year. This setting controls the granularity you can use for the field in visuals and in the default visual settings in the data source configuration.

    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 visual 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).

    If you select the time zone, the Time Zone dialog appears, allowing you to select the time zone from a drop-down list. You can also select the Apply to all time fields in <data source> checkbox to apply the selected time zone to all the time fields included in this data source definition. Select Apply to apply your time zone changes.

Distinct Count Select (check) or clear (uncheck) the checkbox in the Distinct Count column to enable or disable the distinct count metric in the list of field aggregation functions. See Enable Distinct Counts.

Select in this column to refresh the statistics of the field. This forces Composer to run profiling queries and refresh the statistics (such as minimum, maximum, and unique values) for the field. The data is used by filter panels in the UI. See Trigger Refresh Jobs.

This column is available for all data source types except upload API and flat file data sources. Note this column does not appear unless the data source configuration has been saved at least once.

Filter Display

Use the Filter Display column to set the range of data available in the filters for all data types.

  • For attribute fields, select the Only Allow Custom Values checkbox if you want to enter the names of attributes manually when working in the Filters dialog, since the list of attributes is not displayed.
  • For integer and number fields, expand Custom Range to specify minimum and maximum values for the fields. The Custom Range dialog displays when Custom Range is expanded.
  • For time fields, expand Custom Range to specify to and from dates and times for the fields. The Custom Range dialog displays when Custom Range is expanded.

See Control Filter Dialog Values.

Info Displays information about the field (if any) from the data store.

The Derived Fields Table

The Derived Fields table lists derived fields you have defined for the data and allows you to add others. See Maintain Derived Fields.

The Volume Metric Table

The Volume Metric table allows you to rename or hide the Volume field used in visuals of the data. You can only alter this field if it has not already been used by a visual.

If you disable the Volume property in a data source configuration, it does not appear in visual tooltips. The only exception to this is in histograms which plot the volume or number of records.

The Custom Metrics Table

The Custom Metrics table lists custom metrics you have defined for the data and allows you to define others. See Maintain Custom Metrics.