Category Archives: Google Data Studio

Google Data Studio Report Tutorial

Learn all about Google Data Studio reports in this easy to understand tutorial. Reports in data studio are used to tell stories with data. Every report you create should have some purpose. The purpose can be to provide actionable insight, give recomm...

Guide to Data Types in Google Data Studio

The data type of a data source field determines the kind of data to expect (in the connected data set) when processing the field.  For example, when the data type of a field is ‘Number’, it tells Data Studio to expect a number when processing th...

Understanding Aggregation in Google Data Studio

In the context of Google Data Studio, aggregation is the process of summarizing tabular data. Tabular data is the data which is in the form of a table.  Following is an example of tabular data: You can aggregate/summarize tabular data in Google Data...

Geo Data – Country, Region, Latitude, Longitude in Google Data Studio

Google Data Studio provides the Geo data type for geographical data. You see this data type when you create or edit a data source in Data Studio: Use the Geo data type if you want Data Studio to expect a geographic region (like a city, region, countr...

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

Table of Contents Every function in Data Studio has some purpose Every function in Data Studio has syntax All functions expect one or more parameters Parameters are listed in the syntax All functions return a value Almost all functions have certain r...

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 field...

Working with Timezones in Google Sheets and Google Data Studio

Table of Contents How to find out what timezone Google Sheets is using Changing the date format and timezone in Google Sheets Changing the date format and timezone across all Google Sheets Changing the timezone used by Supermetrics Changing the timez...

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 a Data Set Configuration Error: Following is an example of a data source schem...

How to work with the 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 Revenu...

How to work with the 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

Table of Contents Absolute dates Absolute date types Using incorrect absolute date type Absolute time Data types for absolute time Using incorrect absolute time type Changing a field’s type from absolute date to absolute time Relative dates Rel...

Calculated Fields in Google Data Studio – Tutorial

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

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 in Googl...

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 sources 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: Step-1: Op...

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: Renaming d...

error: Alert: Content is protected !!