Google Data Studio Training

Comparing Data to a Reference Point

Comparing Data to a Reference Point

Introduction Usually marketers want to know how their campaigns are performing over a time period. They would like to be able to group data by specific date ranges if they use the date range filters. This angle give them changes in KPIs over time and let them make calculated decisions. How to set a reference date Click on the chart/report you want to add Navigate to DATA tab on the right hand menu Click on the drop down menu, under the Default Data Range selector Choose the desired reference point. Here is how to set it; When you add a...

Apply a Filter to a Group

Apply a Filter to a Group

Adding a filter to a group Select reports which will have the same filter Click on right mouse button → "Group" On the right menu, navigate to "Filter" section Click +Add a filter Click CREATE NEW FILTER. You can also reuse an existing filter Name the filter. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression. Select the dimension or metric by which to filter. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**). Provide a comparison value for the expression. (Optional) To add an OR clause, click OR on the right of the condition. (Optional) To add an AND clause, click AND below...

Apply a Filter to a Report

Apply a Filter to a Report

Adding a filter to the entire report Select File → Report Settings On the right menu, navigate to "Filter" section Click +Add a filter Click CREATE NEW FILTER. You can also reuse an existing filter Name the filter. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression. Select the dimension or metric by which to filter. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**). Provide a comparison value for the expression. (Optional) To add an OR clause, click OR on the right of the condition. (Optional) To add an AND clause, click AND below the clause. Click SAVE. Photo by Scott Graham on Unsplash...

Applying a Filter to a Page

Applying a Filter to a Page

Adding a filter to a page Select **Page → Current Page Settings ****menu Select DATA tab On the right menu, navigate to "Filter" section Click +Add a filter Click CREATE NEW FILTER. You can also reuse an existing filter Name the filter. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression. Select the dimension or metric by which to filter. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**). Provide a comparison value for the expression. (Optional) To add an OR clause, click OR on the right of the condition. (Optional) To add an AND clause, click AND below the clause. Click SAVE.   Photo...

Applying Filter to a Chart

Applying Filter to a Chart

How to add a filter to a chart? Edit your report. Select the chart or control you want to filter. You can also filter a group of charts and/or controls. Select the DATA tab in the Properties panel. Click +Add a filter. Click CREATE NEW FILTER. You can also reuse an existing filter Name the filter. Select Include or Exclude. Include filters include only data that matches the expression you provide. Exclude filters remove all data that matches the expression. Select the dimension or metric by which to filter. Select the comparison operator (e.g. Equals, Contains, Greater than, **etc.**). Provide a comparison value for the expression. (Optional) To add an OR clause, click OR on the right of the condition....

Introduction to Filters

Introduction to Filters

Introduction Filters refine or reduce the data in your reports. By this, you can focus on the data that is most relevant to your needs. 💡 You can apply a filter to a chart, control, page, or the entire report using the DATA properties tab. There are 2 types of filters: Include filters retrieve only the records that match the conditions. Exclude filters retrieve only the records that DON'T match the conditions. 💡 Filters do not change your raw data, they just change the view scope. Filter conditions and operators are clauses which help you construct complicated filters with logic. Here are list of...

Report Layout

Report Layout

Introduction The way your report appears on the viewer's screen can be controlled from the options in the Layout tab of the Theme and Layout panel. 💡 The Theme and Layout panel appears when no report components are selected. You can display this panel at any time by clicking Theme and Layout in the toolbar. Many of the options described here are also found in the View menu. View Mode Header visibility The header visibility options control the behavior of the report header in view mode. The header contains things like the report title, the share button, and edit button. Always show—the report header is always visible. Auto hide—the report...