.png)
Looker Studio can manage many field types. Each one has its own specific options, and you can always find a way to display your data in the format you wish.
We will see how to change the data type fields and the possibilities here.
There are two ways to modify your data type.
The first one is in a chart. The data type you applied on a metric will only exist for this chart.
The second is in the data source and will be applied to every chart using the metric you configured.
In a chart:
Click on a chart and open the field option.
You can select a new data type in the associate dropdown:
You can also provide more information about the display option in the Display Format dropdown.
For example, for numbers, you can choose the numbers of decimal. For date, you can choose which format to use precisely.
And by clicking the Custom format link, you can find more options to fits your need.
Here is the custom date format option:
Open your data source field list -> Resource -> Manage added data source -> Edit your source (if this does not lead you to a field list, clicks on Field list at the top right of the screen after editing your data source).
Locate the Type column. Here, you can change the data type for a given field.
All charts using this field will be updated with the new configuration.
You cannot manage Display Format in the data source as we did in the chart.
Warning: if your data source is reusable, you are modifying the data type for a metric across all reports using this data source.
