Category Archives: Google Data Studio

Why You Should Avoid Using Functions and Calculated Fields in Data Studio

The use of functions in calculated fields can greatly increase the load time of your reports in the data studio.  Even the use of calculated fields themselves can greatly increase the load time of your data studio reports. If you want to do any type...

How to Edit a Calculated Field in Google Data Studio

In order to edit a data source specific calculated field, follow the steps below: Step-1: Navigate to the Data Source Editor. Step-2: Click on the ‘fx’ symbol next to the calculated field you want to edit: Once you clicked on the ‘fx’ symbol,...

Understanding Functions in Google Data Studio

Functions in Google Data Studio are formulas which are used to:  aggregate data.  do mathematical calculations on your data. manipulate time data.  manipulate geographic location data.  manipulate string data.  Functions make your calculated fie...

Formula Rejection in Google Data Studio

If there is an error in a calculated field formula, you’ll see a warning message, and you won’t be able to save the field. When this happens it means your formula has been rejected by data studio: If you are new to using calculated fields...

Working with Timezones in Google Sheets and Google Data Studio

Some interesting facts about working with timezones: By default, Google Sheets uses the timezone set for your computer. So any date and/or time data that you enter into Google Sheets would be considered to be in the time zone set for your computer. Y...

The ‘Data Set Configuration Error’ in Google Data Studio

If your data source schema is not set up correctly and you create/refresh a report in data studio then your data source is not able to connect to your data set and you see ‘Data Set Configuration Error’:   Following is an example of the data...

How to work with Boolean data type in Google Data Studio

If a data field in your data set can have only one of the two possible values: true or false then you should use the ‘Boolean’ data type while setting up your data source schema. For example, consider the following data set: Here the field ‘Is ...

How to Work with ‘Text’ Data Type in Google Data Studio

When you create or edit a data source in Google Data Studio, you get the option to select the data type of the data source field.  One of the data types supported by Google Data Studio is: ‘Text’: Select the ‘Text’ data type, if you want dat...

Date and Time Data Types in Google Data Studio – Tutorial

When you create or edit a data source in Google Data Studio, you get the option to select the data type of the data source field.  One of the data types supported by Google Data Studio is: ‘Date & Time’: As you can see from the screenshot, G...

Calculated Fields in Google Data Studio – Tutorial

 What is a calculated field? A calculated field is a field that performs some action(s) on other field(s) in your data source or chart via a formula. These actions could be: Arithmetic and math operations Manipulating text, date and geographic inf...

Google Data Studio Number Formats / Data Types

When you create or edit a data source in Google Data Studio, you get the option to select the data type of the data source field.  One of the data types supported by Google Data Studio is: ‘Numeric’:    There are three numeric data types i...

Doing Basic Maths on Numeric Fields via Calculated Fields

Consider the following data sets: The data source schema for this data set should look like the one below: The report created based on this data source would look like the one below: Now let us suppose we need to calculate the following metrics in da...

Understanding Data Source Credentials in Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to change data source credentials via the data source editor: Use this setting to determine how data from this data source can be viewed by others.  The default value ...

Understanding Data Freshness in Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to change ‘data freshness’ setting via the data source editor: Use this setting to determine how frequently the data source should check for fresh data.  If you ar...

How to Share Data Source with others in Google Data Studio

When you create/edit a data source file in Google Data Studio, you see the ‘Share’ button at the top right-hand side of the data source editor: Use the ‘share’ button to share your data source with others.    Follow the steps below: Ste...

How to create and configure a data source in Google Data Studio

Configuring the data source (also known as ‘Data Modeling’) Data modeling consist of customizing your data source fields (dimensions and metrics) so that your reports visualize the data in your desired format. You configure a data source by: Rena...

Data Source in Google Data Studio – Tutorial

What is a data source in Google Data Studio? A data source is a data studio file that is used to define how a connector should provide data from a specific data set to the report(s) in data studio.  You create a data source for a specific data set. ...

Data Source Fields in Google Data Studio – Tutorial

A data source is made up of a set of fields called ‘data source fields’: You see these fields when you create and configure your data source in Google Data Studio: Connectors provide fields from a data set to a data source. Some connectors (like ...

Field editing in reports – Google Data Studio

When you create/edit a data source file in Google Data Studio, you get the option to change ‘Field Editing in Reports’ setting via the data source editor:   Use this setting to allow or stop report editors from changing data source field def...

Dimensions and metrics in Google Data Studio

A dimension is the attribute of visitors to your website. It is used to describe or categorize your data.  For example, let’s say a man aged between 25-34 from London visited your website after clicking on an organic search listing on Google which...

error: Alert: Content is protected !!