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 aggregated (calculated) fields to the data using this tab. The tailored and defined fields on this tab are then used as attributes and metrics for charts that use the data source configuration.
|You must be logged in as an administrator 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), click Next to proceed to the Refresh Tab in the data source configuration wizard. Click Back to return to the Tables/Indices Tab.
The field table is the top table on the Fields tab. It lists all of 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 click the associated with a data field, the date and time of the last refresh for that field display. To refresh your metadata, select Refresh Fields at the bottom of the field table.
|Visible||By default, all the fields are selected and are visible. This means that you can visualize the data from these fields on your charts. If you do not want to use specific fields, clear the corresponding checkboxes.|
|Field ID||The name of the field in the data from the data store. Note that Zoomdata supports only underscores and dashes in data store field names. No other special characters or white space are supported. If your data store uses special characters other than underscores and dashes 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 charts. Change the labels in this column as needed.
The type for each field is defined, by default, by Zoomdata. The default data types are displayed in the Type column. You can change them by selecting another option from the drop-down list.
|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.
|Distinct Count||Select or deselect the checkbox in the Distinct Count column to enable or disable the distinct count metric in the list of field aggregation functions. See Enabling Distinct Counts.|
Select the refresh button in this column to refresh the statistics of the field. This forces Zoomdata 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.
This column is available for all data source types except upload API and flat file data sources.
Use the Filter Display column to set the range of data available in the filters for all data types.
The Derived Fields table lists derived fields you have defined for the data and allows you to add others. See About Derived Fields.
The Volume Metric table allows you to rename or hide the Volume field used in charts of the data. You can only alter this field if it has not already been used by a chart.
The Calculations table lists custom metrics you have defined for the data and allows you to define others. See About Custom Metrics.
Was this topic helpful?