Duplicate a data source field

Step by step instructions on duplicating a metric or dimension in your data source.

Extend the usefulness of a data source by creating new metrics or dimensions based on existing fields. Just duplicate the original field and change the Type and Aggregation.

Use calculated fields to create more complex dimensions or metrics.

Example: Create a new "Count" metric based on the Player dimension.

This example shows a data source for a sports team's roster. You'd like to get a metric for the number of players on the team. The solution: copy the Player dimension and create a Count metric from it.

 

  1. Edit a data source by clicking it in the Home pageEdit your data source.
  2. Click the overflow menu on a fieldLocate the starting field. Mouse over the field name, then click
  3. Click DuplicateClick Duplicate.
  4. The duplicated field appearsThis will give you a new field called "Copy of fieldname." Click the field name to rename it.
  5. Select the Type drop-down menuClick the Type drop-down menu for the new field.
  6. Select a typeSelect the new data type. For example, select Number to create a numeric metric. To create a new dimension, select one of the other data types.
  7. Select the Aggregation drop-down menuIf you are creating a new metric, select the Aggregation.
  8. Select an Aggregation For example, select Count to create a cumulative total of the number of values in that field.
  9. Edit the new field by clicking fxYou can edit your new metric or dimension by clicking the fx tab.

 

Create a metric: an example

It's easy to create new metrics in Data Studio. 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. Hover on Employee ID, then click the context menu More menu
  2. Select Count Distinct from the popup menu.

This will create 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

Click fx at the end of the metric chip to display the formula editor. Learn more about creating calculated fields.


Related resources

Was this helpful?
How can we improve it?