Create, rename, copy, disable, and remove fields

This article explains how to create and modify fields in your data source. To apply changes from your underlying data set, see Refresh data source fields.

Create a new field

The 2 ways of creating new fields in a data source are:

  • 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:

  1. Edit the data source.
  2. To the right of the field you want to count, click More More menu.
  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:

Example sales region data source

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

  1. To the right of Employee ID, click More More menu
  2. Select Count Distinct from the popup 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.

Adding a metric

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

Rename a field

To rename a field:

  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:

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

Disable a field

To disable a field:

  1. Edit the data source.
  2. To the right of the field you want to disable, click More More menu.
  3. Click Disable.
    1. To turn the field back on, follow the same steps and click Enable.

Effects of disabling a field

Disabling 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 Available Fields panel in reports.
  • Calculated fields that use this field might break if the formula becomes invalid without that field.
  • Charts that use this field break.
    • You must remove the disabled field from the chart to get it working again.
  • Filters that use this field break.
    • You must remove or replace the disabled field from the filter to get it working again.

Remove a calculated field

You can permanently delete a calculated field:

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

Effects of removing a calculated field

Removing a calculated field has the following effects:

  • The field is removed from the data source field list.
  • The field is removed from the Available Fields panel in reports.
  • Calculated fields that use this field break.
  • Charts that use this field break.
    • You must remove the broken calculated field field from the chart to get it working again.
  • Filters that use this field break.
    • You must remove or replace the removed field from the filter to get it working again.
Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue