Create, rename, copy, hide, and remove fields

Once you've created a data source, you can add, remove, and change the fields. 

In this article:

• Create a new field
• Rename a field
• Copy a field
• Hide a field
• Remove a field
• Restore a removed field
• Related resources

To apply changes that were made in the underlying dataset to the data source, see Refresh data source fields.

Create a new field

You can create new fields in a data source in two ways:

• Create a new count or count distinct metric from an existing dimension.
• Use calculated fields to create more complex metrics or new dimensions.

Create count and count distinct metrics

To count values in a dimension, follow these steps:

1. Edit the data source.
2. To the right of the field you want to count, click More .
3. Click Count or Count distinct.

The new field is added to the field list and is named "Count (or Count Distinct) of [original field name]." If the data source has a lot of fields, you might have to scroll to see the new field.

Example: Count the number of sales representatives per sales region

Suppose you have a spreadsheet that tracks sales people and the regions they cover:

Employee ID	Sales Region
120134	West
949304	East
039443	South
393930	Central
...	...

 

A simple Google Sheets data source based on this data would look like this:

To find out how many sales people you have in each region, you can create a new metric to count them by following these steps:

1. To the right of Employee ID, click More .
2. Select Count Distinct from the pop-up menu.

This creates a new metric, Count Distinct Employee ID. (You can change this name by clicking the new field.) The new metric can be used in visualizations just as you would any other field.

To edit the formula, at the end of the metric field, click fx.

Rename a field

To rename a field, follow these steps:

1. Edit the data source..
2. Click the name of the field you want to change.
3. Enter a new name.

Effects of renaming a field

When you rename a data source field, the new name is used in the following places:

• Calculated fields that use this field (renaming a field won't break calculated fields)
• The Available Fields panel in reports
• Charts that use this field
  • Exception: if you've renamed this field in a chart, the chart continues to use the name you gave it there. (The field name in the chart overrides the field name in the data source.)

Copy a field

To create a copy of a field, follow these steps:

1. Edit the data source.
2. To the right of the field that you want to copy, click More .
3. Click Duplicate.

Hide a field

Hiding a field disables it. To hide a field, follow these steps:

1. Edit the data source.
2. To the right of the field that you want to hide, click More .
3. Click Hide. To unhide the field, follow the same steps and then click Show.

Effects of hiding a field

Hiding a data source field has the following effects:

• The field appears grayed out in the data source field list.
• The field won't appear in the Properties panel in reports.
• The field won't appear in report metadata or data requests.
• Charts, filters and calculated fields that use this field display an error.

Tip: To fix errors in charts, calculated fields, filters, or other components, remove the hidden field from the broken component.

Remove a field

Removing a field deletes if from the data source. To remove a field, follow these steps:

1. Edit the data source.
2. To the right of the field that you want to remove, click More .
3. Click Remove.

Effects of removing a field

Alert: Removing a calculated field permanently deletes the field. Once a field is removed, you can't get the calculated field back except by recreating it.

Removing a data source field has the following effects:

• The field is removed from the data source field list.
• The field is removed from the Properties panel in reports.
• The field won't appear in report metadata or data requests.
• Charts, filters and calculated fields that use this field display an error.
  

Tip: ​To fix errors in charts, calculated fields, filters, or other components, remove the deleted field from the broken component.

Restore a removed field

To add removed fields back to the data source reconnect the data source or refresh the data source fields.

Related resources

• Model your data
• Calculated fields