Google Data Studio offers many powerful tools to help you analyze data and make better decisions. One such tool is the ability to use filters to narrow down large amounts of information quickly. Filters allow you to select specific values within columns of data easily. This article gives you a detailed look into using filters to find what you want.
When working with filters, it is essential to understand what each value represents. For example, if you search for a specific state, you might enter “California.” However, if you search for a city name, you might enter “San Francisco.” In both cases, the values represent different things.
You can filter your data using various criteria such as time range, date range, geography, dimensions, metrics, and segments. This way, you can get the information you want without going through hundreds of rows of data.
Where can you Apply a Filter?
There are different levels in a dataset—the highest level is report level’, which applies to all pages in the report. Next is ‘page level,’ which applies only to one page. Finally, there is ‘chart level,’ which involves only the charts within that report.
To avoid inheritance, you can uncheck the box labeled ‘inherit.’ This will prevent the filter applied to the parent document from being inherited into child documents.
Right-clicking on a chart will allow you to apply a Page Level or Chart Level filter.
How to Apply a Google Data Studio Filter
When creating a data visualization report, there are many different ways filter the data. You can use filters to show specific values, hide certain columns, or even add a custom label to a column. In this video, I’ll walk you through how to apply a filter to a Google Data Studio dashboard.
Manage Filters
You can apply filters to any data set or charts you are working with. For example, you might want to show just the sales figures for a particular month or compare the sales numbers for different products. To do this, select one of the filters listed above.
Filters can be added to any chart or graph. Drag and drop the filter from the list into the chart area where you wish to use it.
If you have several charts, you can apply the same filter to each of them. Select the desired filter again, and drag and drop it onto each chart.
The following image illustrates how to apply a filter to a chart.
Filter Controls – Giving Viewers the Ability to Filter
The most common question about the Data Visualization tool is how do I make my chart look like this one? Or how do I add this functionality to my dashboard? We thought it might be helpful to explain how you can build filters into your charts.
Filters are used to show only specific values in a dataset. For example, you could filter out certain countries or cities from your visualization. In addition, you can use the filter controls to show only specific dates, months, or even quarters.
You can use the filter controls in many different ways. For example, you can set up a filter to show only the month where the highest number of sales occurred. Or you can show only the months with the lowest average price per item.
Once you have selected the value you want to filter by, you can type it directly into the box or select it from a dropdown menu. If you don’t know the exact name of the field, you can use the search function. Write the word you want to find and hit Enter. When you find the field, click inside the textbox to select it.
To help you understand how filters work, let’s take a closer look at how they work in our Dashboard Builder.
Chart Filters
Create interactive charts using chart filters. This feature allows you to add customized filtering options to your charts. You can filter data based on date ranges, specific values, and custom fields. With chart filters, you can create charts that enable your audience to interact with your dashboard.
Drill Down
The latest version of Tableau Online includes a new “drill down.” This tool lets you quickly dive deeper into the data behind your visualization. For example, you could use it to see the number of people living in each city or county on a map. Or you could look at the percentage of men vs. women in a pie chart.
You can choose what level of detail you want to see. If you’re looking at a large dataset, you might want to start with the highest level of detail. But if you’re working with smaller datasets, you might want to zoom out and see the big picture.
Once you’ve selected the level of detail you want, you’ll see a list of options. To move forward, click on one of the buttons.
To go backward, click on the Up Arrow.
Metric Slider
Metric sliders are used to show multiple values on one chart. They work best with bar charts or pie charts. You can use metric sliders to compare two different metrics across a given period. For example, you could compare traffic growth versus conversion rates over a period. To add a metric slider, follow these steps:
1. Select the type of graph you want to include the metric slider on.
2. Click the down arrow next to the graph and select Add metric slider.
3. Choose the metric you want to display.
4. Set the start date and end date for the metric.
5. Repeat steps 2–4 for each metric you want to compare.
6. Save your changes.
Display the filter manager
The Filter Manager allows you to easily apply date range, location, and language filters to your reports. You can even save custom filters for later use.
Edit a filter
Filter Manager allows you to edit all filters in one place. You can duplicate, edit or delete filters.
You can also create a new filter using Filter Manager.
Duplicate a filter
A reusable filter is just like a regular filter, except that it doesn’t take up space in the report builder. You don’t have to manually copy/paste the code into every report where you want to use the same filter. Instead, you drag the reusable filter onto the desired location in the report.
When adding a reusable filter to the report, you can choose what data sources to include. This makes it easy to reuse the same filter across multiple reports without having to reenter the same information over and over again.
Once you add a reusable filter, it will automatically update anytime you change the underlying data sources.
Remove a filter
Filter Manager allows you to manage all the filters in one place. You can add, delete, and edit filters. You can even create a new filter using the filter manager.
I love Google Data Studio and this site is all about sharing tips and trick and help users get the most of out Google’s free data visualization tool