From the course: Build a No-Code ETL Pipeline with Google BigQuery
Explore Looker Studio features - BigQuery Tutorial
From the course: Build a No-Code ETL Pipeline with Google BigQuery
Explore Looker Studio features
- [Instructor] Let's look at basic style options for my chart. So I will click on the chart, and here I will select STYLE. So I want to have a title for my chart. So I will select this toggle, and I will copy this text over here, go back to where I was, and paste it. And now I have a title. So I can select this text box, press Backspace on my keyboard, and remove it. And then I can move this chart up. Back to STYLE, I have the option to make the bars horizontal if I wanted to. I have the option to change the number of bars. So if I wrote 20, then I would be able to see the first, the 20 biggest brands by maximum stock price. So I should probably remove the number from the title so that I can be flexible with changing the number of columns and have a more generic title like this. I can, of course, change the color of the bars. An interesting option is Show data labels. This will allow me to see, at a glance, the values of the bars. It can get too crowded when I have too many bars, but if I were to go to 15 bars, it would become more readable. But when you select Show data labels, you often want to select Compact numbers as well so that the numbers are a bit more readable. And there are other style options as well. And there are also more options to personalize how the chart looks. But those are the most important style options that I wanted to show you. Now let's see how we can use controls to add flexibility to our charts. So let's imagine that I wanted more control over which brands are displayed in this chart specifically. So I can add a control to do this by going over here to Add a control. And I will want to have a Drop-down list of my brands. Now let us see how we can use controls to add more flexibility to our dashboards. So let's imagine that I wanted more control over which brands are displayed or hidden in this chart specifically. To do that, I can select Add a control, and I would like to see a Drop-down list of my brands. So my control is now on the page, and if I select it, I can see Control field is already Brand_Name. But if I wanted to use another field, I could, of course, click here and select another field for my control. And if I select my Drop-down Control, I can see my brands, and I have the option to exclude some brands. For example, I could exclude Chipotle since it's the biggest brand, and it sort of skews my chart. And you can see here that Chipotle has disappeared from my chart because it has been excluded. Alternatively, I could say that I want to see only Chipotle for the start, and then I could add a few more that I'm interested in. For example, this will show me only the top three stocks in my chart. Now the changes made by this control are not permanent. They're just a tool for exploration. And because of that they are called quick filters. And I can see in this quick filter bar all the quick filters that are currently applied to my dashboard. And I can always press Reset to cancel all of the quick filters. So quick filters that are created by controls, they're a tool for dynamically exploring the dashboard, but they do not create permanent changes in the dashboard. Let us now look at another type of control, which is the Date control. So I can go here to Add a control and select Date range control. And now that I have this control, I can say that I would like to see my chart, not for all of the history that is in my dataset, but for a specific date range. So let's imagine that I want to see what this chart would look like for August 2024. So selecting my control, I will select August 1st in Start Date and the last day of August in End Date. And I will Apply, and you can see that my chart has changed to reflect the values that the brands had in that specific timeframe. Right now, I am looking at a fixed timeframe, meaning August 2024, but I can also have a dynamic timeframe. So by selecting my Date control, I can go here on Fixed and change this to a dynamic value. For example, I could select This quarter to date. So this quarter, we are in Q4 2024. It started on October 1st until today, November 30. And this shows me the data for this quarter. But crucially, as time advances, and we enter a new quarter, 2025 Q1, this chart will change to reflect the value for that quarter. So this is a dynamic time range. It will change with time. Let us now briefly look at permanent filters. So we have seen that controls, like Brand_Name, in our case, they create quick filters, which are just used to explore the data, but they can be easily reset. And these filters will go away if you leave the dashboard and come back to it later. But there's also a way to add permanent filters and to understand the need, let's imagine that we're looking at our dashboard, and we decide that the data for Costco is corrupted. The data that we see here is not correct, so we want to hide it temporarily from our users until we find a way to fix it. So to do that, I will select my chart, and I will scroll down until I find the Filter section. And I have the option here to add a filter. Now here we have the forum that helps us to build our filter. And what we want to do is to exclude rows from our table based on what field? Based on Brand_Name. And specifically, we want to exclude rows where brand name is Equal to Costco. And you can see that it helps me by finding the value. And if I Save, this filter will be now applied to my chart, and you can see that the value for Costco has disappeared. And this filter is permanent in the sense that I can see it here in the Filter section, and it will be active until I actually remove it. And this filter will apply to all my users, and you will stay there permanently. Now, if I wanted to get rid of this filter, I could simply go here and press on this X, and I can see that Costco has appeared again.